Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Scenario:
I have a qlikview app which has field name state and it has following values:
"KY", "CA","PA"
Inherited state has above 3 values in a list box.
added another list box which uses alternate state say "test"
I am in inherited state and selected KY, CA using first list box and on button click, I want to pass KY and CA values to the chart which is rendering using alternate state "test".
I tried using select in field action but it is not reflecting in alternate state.
Thanks
Try with this
='(' & Concat({$}DISTINCT '"' & state & '"', '|') & ')'