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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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