What do you understand by extended interval match function()?



What do you understand by extended interval match function()?..

Answer / Prakash Kumar Rathaur

{"extended_interval_match": "The Extended Interval Match function () in QlikView is used to perform calculations based on intervals other than simple ranges. It allows you to specify custom interval definitions using the DEFINE INTERVAL statement.","example": "DEFINE INTERVAL MYINTERVAL (YEAR, QUARTER, MONTH); LOAD YEAR, Quarter, Month FROM mytable; EXTENDED INTERVAL MATCH (myinterval) Year = [2015-2020]"}

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More QlikView Interview Questions

What is the use of connect statement?

1 Answers  


Explain qlikview’s architecture in brief?

1 Answers  


What do you understand by fact constellation schema?

1 Answers  


What is the use of - export sheet layout?

1 Answers  


What is ETL?

1 Answers  


Which type of load is preferred to load data from previously loaded data?

1 Answers  


Difference between star schema and snow flake schema?

1 Answers  


What additional date fields can you add using a Master Calendar?

1 Answers  


What is inline memory in qlikview ?

1 Answers  


What is incremental load?

1 Answers  


How are all the components of QlikView’s architecture managed?

1 Answers  


What are the three main tasks performed on a QlikView document?

1 Answers  


Categories