Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display only negative margins

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?

2 Replies
MayilVahanan

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
Specialist II
Specialist II

try a calculated dimension.

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

or see the attached file