https://community.qlik.com/t5/QlikView/Need-help-with-this-expression-please/m-p/1546108#M440797 <P>Hi QV users</P><P>I have a question about an expression that i am struggling with: My requirement is based on the below data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IR1.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/6285iC038436D2C6D2BFF/image-size/large?v=v2&amp;px=999" role="button" title="IR1.jpg" alt="IR1.jpg" /></span></P><P>On the X-axis i want a few dimensions like batch date, Country name and a drill down into Network name. The KPI i need to show is under the field : PM_Name (GSM_Success_Rate_WO_TR) and the possible values for it is in the field 'PM_Value'.</P><P>The tricky part is that every Network name has a specific value for the KPI under PM_Name called 'NTR_Conf'. The possible values for NTR_Conf could be any letter F,N, Nan, P or any number as seen in the table above.</P><P>So on the graph i only want to show Dates, Country name (with a network name drill down), but values for 'GSM UL Success Rate WO TR' only when NTR Conf equals 'P' or any number.</P><P>Can this be achieved?&nbsp;</P><P>Regards</P><P>Ravi</P><P>&nbsp;</P> Sat, 16 Nov 2024 04:24:48 GMT rt_new_user 2024-11-16T04:24:48Z https://community.qlik.com/t5/QlikView/Need-help-with-this-expression-please/m-p/1546108#M440797 <P>Hi QV users</P><P>I have a question about an expression that i am struggling with: My requirement is based on the below data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IR1.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/6285iC038436D2C6D2BFF/image-size/large?v=v2&amp;px=999" role="button" title="IR1.jpg" alt="IR1.jpg" /></span></P><P>On the X-axis i want a few dimensions like batch date, Country name and a drill down into Network name. The KPI i need to show is under the field : PM_Name (GSM_Success_Rate_WO_TR) and the possible values for it is in the field 'PM_Value'.</P><P>The tricky part is that every Network name has a specific value for the KPI under PM_Name called 'NTR_Conf'. The possible values for NTR_Conf could be any letter F,N, Nan, P or any number as seen in the table above.</P><P>So on the graph i only want to show Dates, Country name (with a network name drill down), but values for 'GSM UL Success Rate WO TR' only when NTR Conf equals 'P' or any number.</P><P>Can this be achieved?&nbsp;</P><P>Regards</P><P>Ravi</P><P>&nbsp;</P> Sat, 16 Nov 2024 04:24:48 GMT https://community.qlik.com/t5/QlikView/Need-help-with-this-expression-please/m-p/1546108#M440797 rt_new_user 2024-11-16T04:24:48Z https://community.qlik.com/t5/QlikView/Need-help-with-this-expression-please/m-p/1546129#M440798 <P>Could you please share the sample data and desired output so that we replicate it with a logic in qlikview</P> Tue, 19 Feb 2019 06:08:45 GMT https://community.qlik.com/t5/QlikView/Need-help-with-this-expression-please/m-p/1546129#M440798 anushree1 2019-02-19T06:08:45Z