topic Display only negative margins in QlikView https://community.qlik.com/t5/QlikView/Display-only-negative-margins/m-p/519077#M480685 <HTML><HEAD></HEAD><BODY><P>I have a report with dimensions representing products and expressions that sum Sales/Cost/GM%. How can I display products with only negative margins in my report?</P></BODY></HTML> Wed, 13 Nov 2013 13:47:45 GMT 2013-11-13T13:47:45Z Display only negative margins https://community.qlik.com/t5/QlikView/Display-only-negative-margins/m-p/519077#M480685 <HTML><HEAD></HEAD><BODY><P>I have a report with dimensions representing products and expressions that sum Sales/Cost/GM%. How can I display products with only negative margins in my report?</P></BODY></HTML> Wed, 13 Nov 2013 13:47:45 GMT https://community.qlik.com/t5/QlikView/Display-only-negative-margins/m-p/519077#M480685 2013-11-13T13:47:45Z Re: Display only negative margins https://community.qlik.com/t5/QlikView/Display-only-negative-margins/m-p/519078#M480686 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>If my understanding is correct,are you expecting to display only negative values, if so, </P><P>try like this</P><P></P><P>=If(YourExpression &lt; 0, YourExpression)</P></BODY></HTML> Wed, 13 Nov 2013 14:08:31 GMT https://community.qlik.com/t5/QlikView/Display-only-negative-margins/m-p/519078#M480686 MayilVahanan 2013-11-13T14:08:31Z Re: Display only negative margins https://community.qlik.com/t5/QlikView/Display-only-negative-margins/m-p/519079#M480687 <HTML><HEAD></HEAD><BODY><P>try a calculated dimension.</P><P></P><P>=if(Aggr(sum(Margin)&lt;0, Product), Product, 'Null')</P><P></P><P>or see the attached file</P></BODY></HTML> Wed, 13 Nov 2013 14:16:51 GMT https://community.qlik.com/t5/QlikView/Display-only-negative-margins/m-p/519079#M480687 israrkhan 2013-11-13T14:16:51Z