topic Re: selecting data between two dates using calender object in QlikView

selecting data between two dates using calender object

Tue, 30 Nov 2010 09:52:55 GMT

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 .

Re: selecting data between two dates using calender object

Miguel_Angel_Baeyens — Tue, 30 Nov 2010 10:08:15 GMT

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.

selecting data between two dates using calender object

Tue, 30 Nov 2010 10:16:13 GMT

It donot solve my problem

selecting data between two dates using calender object

Miguel_Angel_Baeyens — Tue, 30 Nov 2010 10:44:07 GMT

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

Re: selecting data between two dates using calender object

Fri, 29 Jul 2011 12:17:49 GMT

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

selecting data between two dates using calender object

Anonymous — Fri, 29 Jul 2011 12:18:49 GMT

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.

selecting data between two dates using calender object

Miguel_Angel_Baeyens — Sat, 30 Jul 2011 00:17:48 GMT

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

Re: selecting data between two dates using calender object

Wed, 30 Jan 2013 16:24:30 GMT

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;