selecting data between two dates using calender object

[#1]

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 .

[Miguel_Angel_Baeyens]

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.

[#3]

It donot solve my problem

[Miguel_Angel_Baeyens]

Can you be more specific? How do you want to use those buttons?

[#5]

I acutaly need to do what your sample file is showing, but I cannot find the page anymore.  Can you repost the code?

[Anonymous]

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.

[Miguel_Angel_Baeyens]

Hi,

I have updated the link. Previous one came from the old forums and the structure is completely different.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#8]

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;