Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I Want to use 2 calender objects to select TO & FROM date respectively . And I want to use a button , click on which refect the changes in data according to To & From date selected .
How To apply this.
Explain in Detail .
Hello,
Take a look at this file and check its code. It uses a master calendar and two variables, one for the starting date and the other for the end date. Then, expressions use set analysis.
http://community.qlik.com/qlikviews/1075
Hope this helps.
It donot solve my problem
Can you be more specific? How do you want to use those buttons?
I acutaly need to do what your sample file is showing, but I cannot find the page anymore. Can you repost the code?
Hi There,
Please take a look at a document I uploaded a while ago, maybe this will help:
http://community.qlik.com/qlikviews/1054
Good, luck.
Hi,
I have updated the link. Previous one came from the old forums and the structure is completely different.
Hope that helps.
BI Consultant
OD:
LOAD
Date('01/01/2011' + RowNo() - 1) AS DataStart,
Date('10/01/2011' + RowNo() - 1) AS DataEnd
AUTOGENERATE 3000;
FILTRO:
LOAD
Date('01/01/2011' + RowNo() - 1) AS Data1
AUTOGENERATE 3000;
Inner Join IntervalMatch (Data1) LOAD
DataStart, DataEnd
RESIDENT OD;