topic Filter parameter between two dates. in QlikView

Filter parameter between two dates.

Anonymous — Mon, 23 Jul 2012 12:26:26 GMT

Hi,

We have a reporting requirement where we need to show the report between two dates. That filter could be as a selection criteria in the UI. One side From Date and another side to date. How can we achieve that ?

Best,

Skumar

Re: Filter parameter between two dates.

Mon, 23 Jul 2012 13:09:18 GMT

Dear Shubham, Please see a simple example attached. The Inline data only has three dates to chose from. How to: Step 1: Set your min and max variable in script Step 2: Make two empty variable on front end Step 3: Use slider oblect to creat to and from Step 4: Use Variable from step 2 in expression Best of luck! Regards Rahul

Re: Filter parameter between two dates.

nagaiank — Mon, 23 Jul 2012 13:09:38 GMT

This issue has been discussed several times in the forum.

One post that I could get is here.

You can aslo create two listboxes one for StartDate and the other for EndDate and add action on the listboxes so that any change in these listboxes selects the date field for the values between the two dates.