topic Re: select all prior values in list box in QlikView

select all prior values in list box

Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

I would like to select all prior values / lower values in a list box just by selecting one value.

For example, if I select Q3 2016 than all the values lower than Q3 2016 including it should get selected. So if my date range starts from Q1 2014 than it should select all values starting Q1 2014 to Q3 2016.

Please let me know how to achieve this.

Thank you,

Parth

Re: select all prior values in list box

sunny_talwar — Wed, 08 Jun 2016 17:17:04 GMT

You might be able to use on select triggers to this. But this can get very confusing very quickly.

Re: select all prior values in list box

settu_periasamy — Wed, 08 Jun 2016 17:20:12 GMT

Hi,

I think you need to look on field event trigger in the document properties..

In the select in field, put ="<"Max(Quarter year field)

Note: quarter year field should be dual..

Re: select all prior values in list box

Clever_Anjos — Wed, 08 Jun 2016 17:25:23 GMT

It would be easier and plain you instruct your users to select using The Search String

Re: select all prior values in list box

MarcoWedel — Wed, 08 Jun 2016 23:20:16 GMT

Hi,

another possibility could be to use an additional The As-Of Table

hope this helps

regards

Marco

Re: select all prior values in list box

Clever_Anjos — Thu, 09 Jun 2016 10:55:56 GMT

Good answer

Re: select all prior values in list box

Fri, 10 Jun 2016 14:04:11 GMT

Thank you Marco and all. I was on the right path. It was really helpful.

Regards,

Parth