Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a list box which has three values as
MusicNY
MusicLN
MusicAsia
I also have one straight table chart with dimension as region and expression as total, with values as somewhat like this
NY 2300
LN 5000
HK 8965
TK 5486
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,
Thanks
check the attachment using trigger.
Have a Trigger on that field to select the Region
You can set a Field Trigger from "Document Properties" --> Triggers Tab
I think, we can do this in some ways. One solution would using 'Conditional enable'
sample attached
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..
Regards,
check the attachment using trigger.
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.
I think, you can just add two single quotes.