Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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)

Tags (1)
3 Replies
stigchel
Honored Contributor

Re: Provide the solution for the below scenario?

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

Re: Provide the solution for the below scenario?

Please provide personal addition QVW file.

stigchel
Honored Contributor

Re: Provide the solution for the below scenario?

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)

Community Browser