topic Re: Date range selection help in QlikView

Date range selection help

Anonymous — Tue, 26 Aug 2014 12:56:23 GMT

In the attached file I am trying to get the date selections to effect the table and show a to - from date in the current selections box. I seem to have everything in place, but it still does not work. Any help on this will be greatly appreciated.

Re: Date range selection help

ashfaq_haseeb — Tue, 26 Aug 2014 13:18:43 GMT

Hi,

Check if this helped.

Regards

aSHFAQ

Re: Date range selection help

Anonymous — Tue, 26 Aug 2014 13:53:35 GMT

Ashfaq,

That is it. How did you make it work?

Re: Date range selection help

ashfaq_haseeb — Tue, 26 Aug 2014 13:55:55 GMT

Hi,

Your date was not formatted properly.

Correct Expression

='>=' & Date(vPlaceStart, 'MM/DD/YYYY') & '<=' & Date(vPlaceEnd,'MM/DD/YYYY')

and remove = sign from field.

look at attached image.

Regards

ASHFAQ

Re: Date range selection help

israrkhan — Tue, 26 Aug 2014 13:59:11 GMT

See this video too... will show you how to select date ranges...

Selecting Arbitrary Date Ranges

Re: Date range selection help

Anonymous — Tue, 26 Aug 2014 14:19:39 GMT

Awesome, thank you for your help!