topic Re: action condition based on selected value and possible values in QlikView

action condition based on selected value and possible values

shawnqlikfv — Tue, 22 Apr 2014 13:06:02 GMT

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

Re: action condition based on selected value and possible values

Gysbert_Wassenaar — Tue, 22 Apr 2014 13:09:29 GMT

On the Layout tab of the properties window of the chart you can enable the option Conditional (under Show) and enter an expression to show the chart only under the right conditions. Something like =substringcount(concat(distinct [State Values],','),'California','Washington'). This expression will see if the string California or the string Washington is in the list of concatenated State Values values.

Re: action condition based on selected value and possible values

Anonymous — Tue, 22 Apr 2014 13:10:02 GMT

in layout tab, type this in for show condition :

getfieldselections(State)='California' or getfieldselections(State)='Washington'

Re: action condition based on selected value and possible values

its_anandrjs — Tue, 22 Apr 2014 13:10:41 GMT

If have any sample data then provide might be you can use

GetFieldSelections function for string selection

Re: action condition based on selected value and possible values

shawnqlikfv — Tue, 22 Apr 2014 13:13:52 GMT

Hi,

Not sure if I follow your comment. Please clarify. Thanks.

Re: action condition based on selected value and possible values

its_anandrjs — Tue, 22 Apr 2014 13:22:04 GMT

In the chart layout properties write a code like

If( Getfieldselections(State)='California' or Getfieldselections(State)='Washington',1,0)

Re: action condition based on selected value and possible values

shawnqlikfv — Tue, 22 Apr 2014 13:30:04 GMT

I appreciate the response. Instead of hardcoding 'California' or 'Washington', can a matching result process be dynamic from the State Values table ? The conditions are fluid so hardcoding them is not advised.

Re: action condition based on selected value and possible values

shawnqlikfv — Tue, 22 Apr 2014 13:30:40 GMT

Re: action condition based on selected value and possible values

shawnqlikfv — Tue, 22 Apr 2014 13:30:40 GMT

Re: action condition based on selected value and possible values

Anonymous — Tue, 22 Apr 2014 13:36:50 GMT

if there is a particular logic you can try that...but to show/hide based on a particular condition you would need to input that particular condition in the layout tab.

i suggest thath you attach a sample app to get faster and a specific solution.

Re: action condition based on selected value and possible values

Gysbert_Wassenaar — Tue, 22 Apr 2014 13:54:43 GMT

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?

Re: action condition based on selected value and possible values

shawnqlikfv — Tue, 22 Apr 2014 14:28:52 GMT

I just attached a .qvw file with additional info.

Re: action condition based on selected value and possible values

shawnqlikfv — Tue, 22 Apr 2014 14:55:52 GMT

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

Re: action condition based on selected value and possible values

Tue, 22 Apr 2014 15:08:25 GMT

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!

Re: action condition based on selected value and possible values

shawnqlikfv — Tue, 22 Apr 2014 15:23:36 GMT

Patick,

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