Discussion Board for collaboration related to QlikView App Development.
I have a list box which has three values as
I also have one straight table chart with dimension as region and expression as total, with values as somewhat like this
I also have a current selections box which shows me the current selections
Want i want to achieve is when i click on a a value of the list box, say MusicNy then the region NY should be selected and shown in the current selection, and when i click on MusicAsia then region HK and TK must be selected.
and If i clear all then everything gets clear all.
I tried to put a set analysis in the expression of the straight table, but its only limited to that table, i want the region selection to be global,
I did apply a filter using the Trigger, but i am not able to apply filter for 2 values like HK and TK for MusicAsia.
Moreover its not getting clear with clear button in one go.
This is correct but its in a expression, as i said i wanted it globally like if a new block/ chart is created tomorrow then i will not have to add it in expression all the time.
It should simply be a filter like a list box selection or something else..
thanks! this works
can i add one more thing to it, lets say the regions list one null and it has some total count.
i want to include this null in every selection of list box along with respective region.
So now as you have the pipe introduced, how can i add the null from the region list.