Display only negative margins - Qlik Community

Report Inappropriate Content · ‎2013-11-13

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?

MayilVahanan · ‎2013-11-13

HI

If my understanding is correct,are you expecting to display only negative values, if so,

try like this

=If(YourExpression < 0, YourExpression)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

israrkhan · ‎2013-11-13

try a calculated dimension.

=if(Aggr(sum(Margin)<0, Product), Product, 'Null')

or see the attached file