Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formula Implementation

Hi,

I have table chart and have one KPI like the below formula.

SUM(Sales+Profit+Revenue+Gain+Value) where Sales+Revenue+Loss-gain>0, I am not sure how to implement this kind of logic, I tried to put Sales+Revenue+Loss-gain in variable and use it in the SUM SET expression, but I believe we can't use variable on left side for the comparison.

Can you pls assist me to achieve this formula.

Thanks,

2 Replies
sunny_talwar

Have you tried this:

If(Sum(Sales+Revenue+Loss-gain) > 0, Sum(Sales+Profit+Revenue+Gain+Value)) as your expression

Best,

Sunny

MarcoWedel

Hi,


one possible solution could be:


SUM(If(Sales+Revenue+Loss-gain>0 , Sales+Profit+Revenue+Gain+Value))


hope this helps


regards


Marco