https://community.qlik.com/t5/QlikView/Need-help-with-Expression/m-p/1546105#M440743 <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:51 GMT rt_new_user 2024-11-16T04:24:51Z https://community.qlik.com/t5/QlikView/Need-help-with-Expression/m-p/1546105#M440743 <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:51 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Expression/m-p/1546105#M440743 rt_new_user 2024-11-16T04:24:51Z