topic Provide the solution for the below scenario? in QlikView

Provide the solution for the below scenario?

Sat, 16 May 2015 08:54:27 GMT

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)

Re: Provide the solution for the below scenario?

stigchel — Sat, 16 May 2015 11:39:43 GMT

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

Re: Provide the solution for the below scenario?

Sat, 16 May 2015 13:52:54 GMT

Please provide personal addition QVW file.

Re: Provide the solution for the below scenario?

stigchel — Sat, 16 May 2015 14:48:30 GMT

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)