selection of object based on other object

[ashishtams]

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

[boorgura]

Have a Trigger on that field to select the Region

You can set a Field Trigger from "Document Properties" --> Triggers Tab

[settu_periasamy]

I think, we can do this in some ways. One solution would using 'Conditional enable'

sample attached

[ashishtams]

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.

[ashishtams]

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,

[settu_periasamy · Accepted solution]

check the attachment using trigger.

[ashishtams]

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.

[settu_periasamy]

I think, you can just add two single quotes.