topic Selected Dimensions shown in Text in QlikView

Selected Dimensions shown in Text

Thu, 21 Aug 2014 12:17:49 GMT

Hello,

so I know how to get a Filter/Dimension that is set into a Text with concat. My Problem now is that I got a dimension where several Options are choosen (Stage = 2,3,4,5,6,7). Till now I only get the first choosen Stage, e.g. 2, but I would like to have all choosen ones.

Anyone knows How I get to this?

Thanks,

Peter

Re: Selected Dimensions shown in Text

tresB — Thu, 21 Aug 2014 12:21:47 GMT

You know using concat. Did you try like:

=Concat( Distinct Stage, ',') in a textbox?

Re: Selected Dimensions shown in Text

marcus_sommer — Thu, 21 Aug 2014 12:25:48 GMT

Besides concat() you could also use getfieldselections() and getcurrentselections() to show the selected dimensions and values.

- Marcus

Re: Selected Dimensions shown in Text

MayilVahanan — Thu, 21 Aug 2014 12:44:36 GMT

Try with getfieldselections() function. Its gives the selection value for that particular field.

Hope it helps

Re: Selected Dimensions shown in Text

Fri, 22 Aug 2014 07:08:39 GMT

Joop,

thanks, that works!