topic Re: Show values with condition in QlikView https://community.qlik.com/t5/QlikView/Show-values-with-condition/m-p/915880#M981856 <HTML><HEAD></HEAD><BODY><P>you can try with a calculated dimension </P><P><EM>if(aggr(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum(QuantityProductInventory) - Min(SafetyStockLevel)</SPAN>,&nbsp;&nbsp; </EM><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>NameProduct)&lt;0, NameProduct)</EM></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">and check the "Suppress When Value is Null" flag in Dimension tab</SPAN></P></BODY></HTML> Fri, 07 Aug 2015 18:34:00 GMT maxgro 2015-08-07T18:34:00Z Show values with condition https://community.qlik.com/t5/QlikView/Show-values-with-condition/m-p/915879#M981855 <HTML><HEAD></HEAD><BODY><P>I want to show only rows 'NameProduct' (column 1)&nbsp; with condition negative difference between columns 2 and 3 : </P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95386_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Column 1 = Dimension = NameProduct</P><P>Column 2 = Expression = Sum(QuantityProductInventory)</P><P>Column 3 = Expression = Min(SafetyStockLevel)</P><P>Column 4 = Expression = Sum(QuantityProductInventory) - Min(SafetyStockLevel)</P></BODY></HTML> Fri, 07 Aug 2015 17:33:14 GMT https://community.qlik.com/t5/QlikView/Show-values-with-condition/m-p/915879#M981855 2015-08-07T17:33:14Z Re: Show values with condition https://community.qlik.com/t5/QlikView/Show-values-with-condition/m-p/915880#M981856 <HTML><HEAD></HEAD><BODY><P>you can try with a calculated dimension </P><P><EM>if(aggr(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum(QuantityProductInventory) - Min(SafetyStockLevel)</SPAN>,&nbsp;&nbsp; </EM><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>NameProduct)&lt;0, NameProduct)</EM></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">and check the "Suppress When Value is Null" flag in Dimension tab</SPAN></P></BODY></HTML> Fri, 07 Aug 2015 18:34:00 GMT https://community.qlik.com/t5/QlikView/Show-values-with-condition/m-p/915880#M981856 maxgro 2015-08-07T18:34:00Z Re: Show values with condition https://community.qlik.com/t5/QlikView/Show-values-with-condition/m-p/915881#M981857 <HTML><HEAD></HEAD><BODY><P>Perfect !!! Thx a lot...</P><P></P><P>Stanley</P></BODY></HTML> Fri, 07 Aug 2015 19:28:20 GMT https://community.qlik.com/t5/QlikView/Show-values-with-condition/m-p/915881#M981857 2015-08-07T19:28:20Z