topic Re: Re: Alternate state multiple select in listbox's in QlikView

Alternate state multiple select in listbox's

Chernov — Sun, 12 Jan 2014 23:05:21 GMT

i create simple data:

Load RecNo() as ID, * Inline
[ShopName
Shop-01
Shop-02
Shop-3
Shop-4
Shop5
Shop6];

create 2 alternate states: State1 and State2

for select one value from state1 to state2 and create trigger on select ShopName action : select in field ShopName, and value =ShopName this work fine.

But i want to select multiple shop's - how i can do this ?

Re: Alternate state multiple select in listbox's

whiteline — Mon, 13 Jan 2014 07:21:59 GMT

Hi.

May be like this:

=Concat({State1+State2} ShopName,' | ')

Re: Alternate state multiple select in listbox's

Chernov — Mon, 13 Jan 2014 07:40:12 GMT

not work

Re: Re: Alternate state multiple select in listbox's

whiteline — Mon, 13 Jan 2014 18:41:55 GMT

Ah, do you want to make selection for State2 relative to State1 ?

If so, you can do it directly without variable, using OnSelect trigger for ShopName field, see the screenshoot.

You have to use explicit state and add the braces like this ='(' & Concat({State1} ShopName, ' | ') &')'

Also you have to set the state for the action.

add:

to be completely sure you can also add the quotes:

='("' & Concat({State1} ShopName, '" | "') & '")'

Re: Alternate state multiple select in listbox's

Chernov — Mon, 13 Jan 2014 22:05:41 GMT

yeah! thanks