topic Re: Multi Metric selection in QlikView https://community.qlik.com/t5/QlikView/Multi-Metric-selection/m-p/454371#M489602 <HTML><HEAD></HEAD><BODY><P>I'm responding to myself ...<BR />Well Jamie ... first I want say&nbsp; ... "You look Marvelous!!!"&nbsp;&nbsp;&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P><P> <BR />Okay ... I found the answer by trial and error ...</P><P>For each expression you would add a condition like this ...</P><P>GetFieldSelections(_metricPickList) like&nbsp; '*Sales Units*'&nbsp; <BR />GetFieldSelections(_metricPickList) like '*Sales Dollars*'&nbsp; <BR />GetFieldSelections(_metricPickList) like&nbsp; '*Margin*'&nbsp; </P><P></P><P>Thanks Jamie you rock!</P></BODY></HTML> Thu, 25 Oct 2012 15:58:43 GMT 2012-10-25T15:58:43Z Multi Metric selection https://community.qlik.com/t5/QlikView/Multi-Metric-selection/m-p/454370#M489601 <HTML><HEAD></HEAD><BODY><P>What if I wanted to show a line chart with one or more of the following:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales Dollars</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sale Units</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Margin%</P><P></P><P>Some users may be focused on a particular Metric, I want to be able allow them to select the metric they are interested in.</P><P></P><P>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 ....</P><P>&nbsp; <SPAN style="font-size: 8pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _metricPickList ='Sales Dollars' </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">What I really want it something like this, but I can't get the syntax right.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _metricPickList in ('Sales Dollars' , 'Sales Units')</SPAN></P></BODY></HTML> Thu, 25 Oct 2012 15:15:41 GMT https://community.qlik.com/t5/QlikView/Multi-Metric-selection/m-p/454370#M489601 2012-10-25T15:15:41Z Re: Multi Metric selection https://community.qlik.com/t5/QlikView/Multi-Metric-selection/m-p/454371#M489602 <HTML><HEAD></HEAD><BODY><P>I'm responding to myself ...<BR />Well Jamie ... first I want say&nbsp; ... "You look Marvelous!!!"&nbsp;&nbsp;&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P><P> <BR />Okay ... I found the answer by trial and error ...</P><P>For each expression you would add a condition like this ...</P><P>GetFieldSelections(_metricPickList) like&nbsp; '*Sales Units*'&nbsp; <BR />GetFieldSelections(_metricPickList) like '*Sales Dollars*'&nbsp; <BR />GetFieldSelections(_metricPickList) like&nbsp; '*Margin*'&nbsp; </P><P></P><P>Thanks Jamie you rock!</P></BODY></HTML> Thu, 25 Oct 2012 15:58:43 GMT https://community.qlik.com/t5/QlikView/Multi-Metric-selection/m-p/454371#M489602 2012-10-25T15:58:43Z