Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
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.