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

Provide the solution for the below scenario?

Scenario:

Assume,if we are having 2 list boxes, first list box is having date filed with dates from 1-jan-2015 to till date,

And 2nd list box also having same values.

Q.if we select any date from 1st list box, 2nd list box has to disply the dates which are greater than selected date.

(Ex: if we select 1-Apr-2015, 2nd list box has to display the dates greater than 1-Apr-2015)

3 Replies
stigchel
Partner - Master
Partner - Master

I'm guessing this for a scenario where you choose a from and a to date. You might also consider using two variables, which you can set using two slider\calendar objects. If it needs to be a listbox on the same field, put it in an alternate state e.g. ToDate and use an expression like

=Aggr(Only({ToDate<Date={">=$(=Min({$}Date))"}>} Date),Date)

See example attached

Not applicable
Author

Please provide personal addition QVW file.

stigchel
Partner - Master
Partner - Master

That's as far as I know not possible, you can still use my above expression in a list box with an alternate state (see help)