topic Re: List Box Question in QlikView

List Box Question

Tue, 16 Sep 2014 19:32:31 GMT

All,

Is there any possible way to have a second value automatically select when I make a selection in a list box? For example, if I select week 5 in the list box below, is there any trick to have week 1 selected as well? And when I select week 6, have week 2 selected- and so on... Ideally I'd like to be able to select any week in the list box and have the week that's 4 weeks prior automatically selected.

I know you can manually select the two, but I really would like it to be automatic.

Thanks in advance

Re: List Box Question

Anonymous — Tue, 16 Sep 2014 19:40:17 GMT

Yes - see attached

Re: List Box Question

Tue, 16 Sep 2014 19:53:39 GMT

Awesome!

Hang with me here because I'm very new to Qlikview...

How exactly do you code the list box to perform that?

Re: List Box Question

Anonymous — Tue, 16 Sep 2014 19:59:39 GMT

See Document Properties, tab Triggers. I've added an Action on event OnSelect on the field Week.

Action is ToggleSelect

Field is Week

Search string is =Week-4

So, every time you select a Week, the week which is =week-4 is selected, if it exists.

Re: List Box Question

Wed, 17 Sep 2014 12:28:13 GMT

Thanks so much!