topic Please correct my expression in QlikView https://community.qlik.com/t5/QlikView/Please-correct-my-expression/m-p/745543#M472969 <HTML><HEAD></HEAD><BODY><P></P><P><SPAN style="color: #0000ff; font-size: 10pt;">Count</SPAN><SPAN style="font-size: 10pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 10pt;">[Pump ID]</SPAN><SPAN style="font-size: 10pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">P</SPAN><SPAN style="font-size: 10pt;">({1&lt;</SPAN><SPAN style="color: #800000; font-size: 10pt;">[%Link Pump Group]</SPAN><SPAN style="font-size: 10pt;">={</SPAN><SPAN style="color: #800000; font-size: 10pt;">"*$(=count(DISTINCT [%Link Pump Group])-count(DISTINCT{&lt;[DYN Group Param Id]=p([DYN Group Param Id])&gt;}[%Link Pump Group]))*"</SPAN><SPAN style="font-size: 10pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 10pt;">[Pump ID]</SPAN><SPAN style="font-size: 10pt;">)&gt;}</SPAN><SPAN style="color: #800000; font-size: 10pt;">[Pump ID]</SPAN><SPAN style="font-size: 10pt;">)<BR /><BR /> </SPAN></P><P><SPAN style="font-size: 10pt;">As I want to get the count of PUMP ID</SPAN></P><P><SPAN style="font-size: 10pt;">based on the values coming from </SPAN></P><P><SPAN style="font-size: 10pt;">(=count(DISTINCT [%Link Pump Group])-count(DISTINCT{&lt;[DYN Group Param Id]=p([DYN Group Param Id])&gt;}[%Link Pump Group])</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">this expression returns 76 but when I placed this espression then it is not wotking . actually this 76 is my count but I want 76 values coming in my SQL script.</SPAN></P><P><SPAN style="font-size: 10pt;">Is this right or please correct me.</SPAN></P></BODY></HTML> Sun, 30 Nov 2014 17:02:35 GMT agni_gold 2014-11-30T17:02:35Z Please correct my expression https://community.qlik.com/t5/QlikView/Please-correct-my-expression/m-p/745543#M472969 <HTML><HEAD></HEAD><BODY><P></P><P><SPAN style="color: #0000ff; font-size: 10pt;">Count</SPAN><SPAN style="font-size: 10pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 10pt;">[Pump ID]</SPAN><SPAN style="font-size: 10pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">P</SPAN><SPAN style="font-size: 10pt;">({1&lt;</SPAN><SPAN style="color: #800000; font-size: 10pt;">[%Link Pump Group]</SPAN><SPAN style="font-size: 10pt;">={</SPAN><SPAN style="color: #800000; font-size: 10pt;">"*$(=count(DISTINCT [%Link Pump Group])-count(DISTINCT{&lt;[DYN Group Param Id]=p([DYN Group Param Id])&gt;}[%Link Pump Group]))*"</SPAN><SPAN style="font-size: 10pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 10pt;">[Pump ID]</SPAN><SPAN style="font-size: 10pt;">)&gt;}</SPAN><SPAN style="color: #800000; font-size: 10pt;">[Pump ID]</SPAN><SPAN style="font-size: 10pt;">)<BR /><BR /> </SPAN></P><P><SPAN style="font-size: 10pt;">As I want to get the count of PUMP ID</SPAN></P><P><SPAN style="font-size: 10pt;">based on the values coming from </SPAN></P><P><SPAN style="font-size: 10pt;">(=count(DISTINCT [%Link Pump Group])-count(DISTINCT{&lt;[DYN Group Param Id]=p([DYN Group Param Id])&gt;}[%Link Pump Group])</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">this expression returns 76 but when I placed this espression then it is not wotking . actually this 76 is my count but I want 76 values coming in my SQL script.</SPAN></P><P><SPAN style="font-size: 10pt;">Is this right or please correct me.</SPAN></P></BODY></HTML> Sun, 30 Nov 2014 17:02:35 GMT https://community.qlik.com/t5/QlikView/Please-correct-my-expression/m-p/745543#M472969 agni_gold 2014-11-30T17:02:35Z