topic Using Alternate States to Select Multiple Values in a List Box with Different Attributes in QlikView

Using Alternate States to Select Multiple Values in a List Box with Different Attributes

Josh_Good — Mon, 31 Dec 2012 20:59:50 GMT

This video show how to use alternate states to select multiple values in a list box when the members of the list box have different attributes. In this example a list of hockey players is used to select players to fill each position on the team. The QVW created in the video is included in this post.

http://www.youtube.com/watch?v=jXybIzLWtAQ

Re: Using Alternate States to Select Multiple Values in a List Box with Different Attributes

sureshbaabu — Mon, 12 May 2014 11:26:23 GMT

Hi Josh,

Thanks for posting this document. it was very useful for me.

I have question about selecting multiple values from a list box and passing it through.

For e.g.: If I have to select more than 1 person from the Left Wings list;

how should we change the expression on the actions to achevie this? I tried with the open and close brackets,but it dint help.

Thank you!!

Re: Using Alternate States to Select Multiple Values in a List Box with Different Attributes

Josh_Good — Mon, 12 May 2014 14:46:18 GMT

This expression should work:

='(' & Concat(DISTINCT {[Left Wing]} Player, '|') & ')'

The results you are looking for is to have the expression resulting in:

(Name1|Name2|Name3)

Re: Re: Using Alternate States to Select Multiple Values in a List Box with Different Attributes

sureshbaabu — Tue, 13 May 2014 05:08:51 GMT

Josh,

I too tried the same initially but with this expression, it doesn’t read any selections from the list box,

Could you please take a look at it?

Thanks

Re: Re: Using Alternate States to Select Multiple Values in a List Box with Different Attributes

Josh_Good — Tue, 13 May 2014 14:34:29 GMT

Hi Suresh,

The reason it isn't work is because the players have spaces in their names. So you need to replace the space with a single character wild card - the question mark - '?'

Try this expression for your selection:

=replace('(' & Concat(DISTINCT {[Left Wing]} Player, '|') & ')',' ','?')

Re: Re: Using Alternate States to Select Multiple Values in a List Box with Different Attributes

sureshbaabu — Tue, 13 May 2014 15:38:14 GMT

HI Josh,

That's cool..Thanks a lot for your time in explaining it clearly. It's wonderful !!!

Thanks again!!