Date Range Selection

[#1]

Hi All,

Could you help to check my QVW file?  I encounter a select issue below:

When I select the date, the data does not change. Many thanks.

Below is my script:

Sales:
Load * Inline
[
Date, Sales
2014/01/01, 100
2014/02/01, 200
2014/02/11, 1200
2014/03/11, 200
2014/04/11, 1000
2014/05/11, 800
2014/06/11, 225
2014/07/11, 120
2014/08/01, 280
];

MinMaxDate:
Load
    Min(Date) as MinDate,
    Max(Date) as MaxDate
Resident Sales;

Let vMinDate = PEEK('MinDate',0,'MinMaxDate');
Let vMaxDate = PEEK('MaxDate',0,'MinMaxDate');

Drop Table MinMaxDate;

Calendar:
Load
Date($(vMinDate) + IterNo() - 1) as Date
AutoGenerate 1
While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);

[sunny_talwar]

Try now

[#3]

Hi Sunny,

For my Qlikview is personal version, so I could not open your QVW file. Could you help to copy the script to me directly? Thanks a lot.

[sunny_talwar · Accepted solution]

I added triggers to your two variables

1) vFromDate -> Action: Select in Field -> Field: Date -> Search String: ='>=' & Date(vFromDate) & '<=' & Date(vToDate)

2) vToDate- > Action: Select in Field -> Field: Date -> Search String: ='>=' & Date(vFromDate) & '<=' & Date(vToDate)

[#5]

Hi Sunny,

I added the triggers following your instruction and it works fine. Thanks again.