topic Re: How to link two list boxes? in QlikView

How to link two list boxes?

Sat, 11 Jul 2015 16:19:54 GMT

I have two list boxes one for case creation date and one for install base date. I want to link these two list boxes so that when I select a date in case creation list box all the values in install base date list box must be selected till that date.

For example, if I select a month Jan 2015 than all the months till Jan 2015 should get selected in the other list box.

I am new to Qlikview and tried searching for this type of post but couldn't find it. If some one can help me with this or point me to the appropriate post, I'd greatly appreciate it.

Thanks,

Parth

Re: How to link two list boxes?

Anonymous — Sat, 11 Jul 2015 17:18:27 GMT

See a simple example attached. Make selections in field A and see the result in B. Is it what you need?

Re: How to link two list boxes?

Sat, 11 Jul 2015 18:22:17 GMT

Yes, how did you do it? I checked properties of both list boxes and checked the script, but didn't find the logic which does this.

Re: How to link two list boxes?

Anonymous — Sat, 11 Jul 2015 19:27:41 GMT

Sorry...

See Document properties - Triggers. There is an action there for field A on select, it selects in field B, and the search string is

='<=' & A

Re: How to link two list boxes?

Sat, 11 Jul 2015 20:31:01 GMT

Thanks Michael. It worked

Have a good one!!