topic Re: Get selected value in QlikView

Get selected value

Fri, 30 May 2014 07:46:16 GMT

Hi!

I have a table in the script:

T1:

load * inline [

f1, f2

1, a

2, b

3, c

];

In List Box I chose field 'f1'.

I can get the selected value of f1-field through getfieldselections('f1') function.

Question: how to get the corresponding value of the f2-field ?

Thanks!

Re: Get selected value

jonathandienst — Fri, 30 May 2014 07:48:53 GMT

If you have made a selection in f1, there is only one possible value of f2, one value will be white (possible) in a list box for f2. Or reference it directly:

=f2

HTH

Jonathan

Re: Get selected value

MayilVahanan — Fri, 30 May 2014 07:54:44 GMT

Try like this

=IF(GetSelectedCount(f1) > 1, Concat(DISTINCT f2,','))

Re: Get selected value

sunilkumarqv — Fri, 30 May 2014 07:59:18 GMT

Create a listbox for f1 and make a selection

put this in you text box and check this

=IF(GetFieldSelections(f1) ,f2)

Re: Get selected value

Fri, 30 May 2014 08:06:54 GMT

Thank you all. It turns out it is very easy