topic Re: Formula Implementation in QlikView

Formula Implementation

Sun, 26 Apr 2015 18:07:47 GMT

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,

Re: Formula Implementation

sunny_talwar — Sun, 26 Apr 2015 18:49:01 GMT

Have you tried this:

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

Best,

Sunny

Re: Formula Implementation

MarcoWedel — Sun, 26 Apr 2015 21:12:27 GMT

Hi,

one possible solution could be:

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

hope this helps

regards

Marco