Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter dates in list box

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

6 Replies
Not applicable
Author

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
Luminary Alumni
Luminary Alumni

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.

Handling Start and End Dates

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.

Regards,

Jagan.

Not applicable
Author

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

jagan
Luminary Alumni
Luminary Alumni

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
MVP
MVP

maybe this .qvw is personal edition compatible

The Basics about Dates, Date Ranges and Set Analysis

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