topic Re: list boxes multiple selections in QlikView

list boxes multiple selections

Mon, 04 Jun 2012 06:50:02 GMT

Hello,

I have a problem to set a fixed selection in two list boxes at the same time.

The problem is this:

I have two list boxes A and B. List box A containes Conso, Unconso.

List box B containes Total, Subtotal, line.

I want to set a fixed selection when Conso is selected, that automatically Total is also selected.

Does anybody know how to do this?

Gert

Re: list boxes multiple selections

Mon, 04 Jun 2012 08:20:38 GMT

Hi,

You need to use Field Event Trigger and define OnSelect Trigger.

OnSelect event of first field define the event to "Select in field" in second field.

Find attached a sample file.

Hope it helps.

Regards

Amar Nath

Re: list boxes multiple selections

Mon, 04 Jun 2012 09:59:04 GMT

Thanks!

Re: list boxes multiple selections

rob_greene — Sun, 08 Jul 2012 13:52:15 GMT

Hi Amar, that was realy helpful,

Do you have the syntax if you want to select Line AND Subtotal with the selection of conso ?

In my app I want to select multiple values in the dimension.

I have tried ('Line','Subtotal') and ('Line'|'Subtotal') and various other separators, but with no luck.

Many thanks

Rob

Re: list boxes multiple selections

nagaiank — Sun, 08 Jul 2012 16:49:04 GMT

Try the search string (Line|Subtotal). Some more details are available here.

Re: list boxes multiple selections

rob_greene — Sun, 08 Jul 2012 20:30:49 GMT

Thanks krishnamoorthy, you were right. Thank you for pointing me in the right direction.

This is the syntax that worked for me in the end. I had to put the desired values in brackets within single quotes.
I put an IF statement in too because I needed it in my app. Thought it would be useful.

=IF(GetFieldSelections(F1)='Conso','(Line|Subtotal)')

All the best

Rob