topic Re: Positive and Negative Values to capture with Count in App Development https://community.qlik.com/t5/App-Development/Positive-and-Negative-Values-to-capture-with-Count/m-p/1955562#M78792 <P>Expression for Mismatch column</P> <P>&nbsp;</P> <P>=if(sign(min(total &lt;Pol&gt; GrossPremium))&lt;&gt;<SPAN>sign(max(total &lt;Pol&gt; GrossPremium)),sum(GrossPremium))</SPAN></P> Thu, 14 Jul 2022 06:04:20 GMT vinieme12 2022-07-14T06:04:20Z Positive and Negative Values to capture with Count https://community.qlik.com/t5/App-Development/Positive-and-Negative-Values-to-capture-with-Count/m-p/1955545#M78791 <P>Dear All,</P> <P>I am stuck in a development part where i need to capture both positive and negative value along with count in a column in pivot&nbsp;</P> <TABLE width="422"> <TBODY> <TR> <TD width="64">Pol</TD> <TD width="64">Tranno</TD> <TD width="102">Gross Premium</TD> <TD width="64">Refund</TD> <TD width="64">Premium</TD> <TD width="64">Mismatch</TD> </TR> <TR> <TD>1</TD> <TD>1</TD> <TD>10</TD> <TD>&nbsp;</TD> <TD>10</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>1</TD> <TD>2</TD> <TD>20</TD> <TD>&nbsp;</TD> <TD>20</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>2</TD> <TD>1</TD> <TD>-20</TD> <TD>-20</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>3</TD> <TD>1</TD> <TD>-30</TD> <TD>-30</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>3</TD> <TD>2</TD> <TD>-40</TD> <TD>-40</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>4</TD> <TD>1</TD> <TD>10</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>10</TD> </TR> <TR> <TD>4</TD> <TD>2</TD> <TD>-20</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>-20</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Where my Policy count is more than 2 and SIGN od Gross Premium is positive and negative i need to move that gross premium amount in mismatch column .&nbsp;</P> <P>&nbsp;</P> Thu, 14 Jul 2022 05:21:58 GMT https://community.qlik.com/t5/App-Development/Positive-and-Negative-Values-to-capture-with-Count/m-p/1955545#M78791 Aanchal 2022-07-14T05:21:58Z Re: Positive and Negative Values to capture with Count https://community.qlik.com/t5/App-Development/Positive-and-Negative-Values-to-capture-with-Count/m-p/1955562#M78792 <P>Expression for Mismatch column</P> <P>&nbsp;</P> <P>=if(sign(min(total &lt;Pol&gt; GrossPremium))&lt;&gt;<SPAN>sign(max(total &lt;Pol&gt; GrossPremium)),sum(GrossPremium))</SPAN></P> Thu, 14 Jul 2022 06:04:20 GMT https://community.qlik.com/t5/App-Development/Positive-and-Negative-Values-to-capture-with-Count/m-p/1955562#M78792 vinieme12 2022-07-14T06:04:20Z Re: Positive and Negative Values to capture with Count https://community.qlik.com/t5/App-Development/Positive-and-Negative-Values-to-capture-with-Count/m-p/1955587#M78798 <P>Thank You&nbsp;</P> Thu, 14 Jul 2022 06:53:00 GMT https://community.qlik.com/t5/App-Development/Positive-and-Negative-Values-to-capture-with-Count/m-p/1955587#M78798 Aanchal 2022-07-14T06:53:00Z