topic Re: Filter dates in list box in QlikView

Filter dates in list box

Tue, 07 Jul 2015 05:03:34 GMT

Hi Team

I have list box in that have around 4 years data that is 2009-Jan-01 to 2012-Dec-01.

Requirement is i wanted to show the dates Start date 2010-Jan-01 End date 2012-july-13 respectively.

below screens are my Start date and End dates

output needs to be below screen

Tue, 07 Jul 2015 05:08:15 GMT

Hi,

How do you want to show it? Based on user Input ?

It is not clear.

If you just want to show Min and Max of a selected date range that you can use Min and Max function.

jagan — Tue, 07 Jul 2015 05:13:14 GMT

Hi,

You have to use Calendar objects and assign the variables to it. Also you have to use this variables in the set analysis expression.

Check this link hope it helps you.

Regards,

Jagan.

jagan — Tue, 07 Jul 2015 05:14:47 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Tue, 07 Jul 2015 05:28:54 GMT

i dnt have to access qvw files because i have been using personal edition so can send me thedata

jagan — Tue, 07 Jul 2015 05:33:24 GMT

Hi,

Create two variables

vMinDate & vMaxDate

Now create two Calendar objects and assign this two variables to each of the object. In Number tab select Date option.

Now in all your charts you have to use the expression like below

=Sum({<Date={'>=$(=Date(vMinDate))<=$(=Date(vMaxDate))'}>}Sales)

Regards,

Jagan.

maxgro — Tue, 07 Jul 2015 05:44:54 GMT

maybe this .qvw is personal edition compatible

Example for start end date with calendar objects is at the top