topic Re: Getfield Selections to another listBox in QlikView

Getfield Selections to another listBox

phaneendra_kunc — Mon, 17 Oct 2011 00:30:23 GMT

Hi All,

I am stuck with this, can any one help me out.

i have 2 list boxes with the same data. i wants to filter the data in one list box with the selections made from another.

see attached to what i am trying to acheive.

Note: The two tables needs to be seperate for my requirement.

Thanks,

Phani

Re: Getfield Selections to another listBox

Mon, 17 Oct 2011 01:29:44 GMT

Hi Phani: check out the attached qv doc. If the second list box is used to show what you've selected in ListBox A, then you could use GetCurrentSelections() and format the display a bit.

Re: Getfield Selections to another listBox

phaneendra_kunc — Mon, 17 Oct 2011 02:18:26 GMT

Hi JasleenP_SR

Thanks for the reply. Current Field Selection will work for showing what i have selected in list box A.

But i am not able to select anything from List box B.

So, once i get the filtered list in the list box B then this List box wii drive another chart.

Thanks,

Phani

Re: Getfield Selections to another listBox

Mon, 17 Oct 2011 03:09:41 GMT

Phani:

In that case you can directly use ListBox A to generate a chart....and something along the following lines can be used in the chart expressions:
=if(index(GetFieldSelections(<ListBox A>), 'Alt') > 0, $(vVariableNameHere),0)

where vVariableNameHere contains the value(s) for Alt.

Better still, use a pick(match) combo and check for all values of ListBox A that you wish to display on a chart.

Re: Getfield Selections to another listBox

phaneendra_kunc — Sat, 29 Oct 2011 18:03:12 GMT

HI JasleenP_SR

So far this is where i got stuck with.

i am able to pass the selections from ListBox A to ListBox B.

but when i clik on any of the filed From List Box B, then in list box A it is selecting "ALL Fields" from ListBox A.

which i dont want.

See attached.