topic Get 5 selected values in 5 variables in QlikView

Get 5 selected values in 5 variables

Mon, 18 Nov 2013 09:16:20 GMT

Hi All,

I have a id column. i want to store each selected id in a variable, how can i achieve that?

Regards,

Gaurav

Re: Get 5 selected values in 5 variables

Gysbert_Wassenaar — Mon, 18 Nov 2013 09:25:49 GMT

var1: =subfield(GetFieldSelections(MyField,';'),';',1)
var2: =subfield(GetFieldSelections(MyField,';'),';',2)

...

var5: =subfield(GetFieldSelections(MyField,';'),';',5)

Re: Get 5 selected values in 5 variables

Mon, 18 Nov 2013 09:28:29 GMT

Hi Gaurav,

Please give me one example how you want it.

Regards,

Santhosh G

Re: Get 5 selected values in 5 variables

Mon, 18 Nov 2013 09:40:35 GMT

Actually,

On selection of id's present in the list box i want individual id's to be in column of table and want information in rows so that i can easily compare different id's.

eg. id1 | id2 | id3

Name Gaurav| Ajay | Vijay

City Delhi | Pune | Mumbai

I want this kind of table once i select id's from list box

Regards,

Gaurav