action condition based on selected value and possible values

[shawnqlikfv]

Hi,

I have an object and only wants to  display it only if a selected value from selection list matches from a set of values.

i.e

I have 1 chart calls  West Region

I have 1 selection box with field name State

I have 1 table State Values containing the possible values for West Region

The West Region chart action based on below criteria

if I select 'California' or 'Washington'  . from State selection box, the West Region chart will appears(.  If I select 'New York'  the West Region chart remains hidden.  Any help on this is greatly appreciated.

State Values

Washington

Nevada

California

Wyoming

Message was edited by: shawn nguyen

[Gysbert_Wassenaar]

I don't understand the requirement. Users can define which states are part of which region? Meaning a user can decide that California no longer is part of West Region, but should be part of East Region?

[shawnqlikfv]

I just attached a .qvw file with additional info.

[shawnqlikfv]

Hi, I’ve attached a .qvw file and additional info to clarify my question. Thanks!

[#5 · Accepted solution]

If Im understanding this correctly, you can use the following statement

=substringcount(concat(distinct [States],','),

GetFieldSelections(Western_States)

)

for the Show property of the table. (See attached).

HTH!

[shawnqlikfv]

Patick, 

That's what I was looking for.  Thank you!!