topic Re: Expression in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/47246#M7867 <HTML><HEAD></HEAD><BODY><P>Use this for 2nd pivot table</P><P>Dimension </P><P>YEAR</P><P></P><P>expression</P><P>SUM(Aggr(IF(SUM(Premium)-SUM(CLAIM)&lt;0,1,0),POLICY_NO,NAME,YEAR))</P></BODY></HTML> Mon, 19 Mar 2018 07:30:26 GMT MK_QSL 2018-03-19T07:30:26Z Expression https://community.qlik.com/t5/QlikView/Expression/m-p/47245#M7866 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have attached sampale QV document with two pivot tables in it. IN my 2nd Pivot table I want to show no of Polcies if there is a negative figure in Profit Figure. I want to display following table</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="196"><TBODY><TR><TD class="xl63" height="17" width="98">YEAR</TD><TD class="xl64" width="98">count</TD></TR><TR><TD align="right" height="17">2015</TD><TD align="right">2</TD></TR><TR><TD align="right" height="17">2016</TD><TD align="right">1</TD></TR><TR><TD align="right" height="17">2017</TD><TD align="right">1</TD></TR></TBODY></TABLE><P>but it actually shows only 2015 year. Can you pls help me</P></BODY></HTML> Mon, 19 Mar 2018 07:21:53 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/47245#M7866 upaliwije 2018-03-19T07:21:53Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/47246#M7867 <HTML><HEAD></HEAD><BODY><P>Use this for 2nd pivot table</P><P>Dimension </P><P>YEAR</P><P></P><P>expression</P><P>SUM(Aggr(IF(SUM(Premium)-SUM(CLAIM)&lt;0,1,0),POLICY_NO,NAME,YEAR))</P></BODY></HTML> Mon, 19 Mar 2018 07:30:26 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/47246#M7867 MK_QSL 2018-03-19T07:30:26Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/47247#M7868 <HTML><HEAD></HEAD><BODY><P>Hi , </P><P></P><P>you could just tweek your expression a little</P><P></P><P>=sum(IF((Premium-CLAIM)&lt;0,1,0))</P><P><IMG alt="Qlik 01.jpg" class="jive-image image-1" src="/legacyfs/online/196687_Qlik 01.jpg" style="height: auto;" /></P></BODY></HTML> Mon, 19 Mar 2018 07:54:48 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/47247#M7868 Anonymous 2018-03-19T07:54:48Z