Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multi Metric selection

What if I wanted to show a line chart with one or more of the following:

                 Sales Dollars

                 Sale Units

                 Margin%

Some users may be focused on a particular Metric, I want to be able allow them to select the metric they are interested in.

So far I have created a chart with the 3 metrics. In the properties box (Expressions), I selected the Conditional check box, but the only option that works is something like this ....

                                        _metricPickList ='Sales Dollars'

What I really want it something like this, but I can't get the syntax right.

                                        _metricPickList in ('Sales Dollars' , 'Sales Units')

1 Reply
Not applicable
Author

I'm responding to myself ...
Well Jamie ... first I want say  ... "You look Marvelous!!!"   


Okay ... I found the answer by trial and error ...

For each expression you would add a condition like this ...

GetFieldSelections(_metricPickList) like  '*Sales Units*' 
GetFieldSelections(_metricPickList) like '*Sales Dollars*' 
GetFieldSelections(_metricPickList) like  '*Margin*' 

Thanks Jamie you rock!