topic Expression Error in QlikView

Expression Error

bhaveshp90 — Sat, 16 Nov 2024 04:27:53 GMT

Hello,

I have a table as shown below,

I am calculating POC-Dec POC = (Current month POC)-(Last year December Month's POC)

(Sum({<Cost_Code={8}>}POC)
-
Above(TOTAL Sum({<MonthYear,Year,Cost_Code={8}>}POC), Num(Month)))

The expression is working fine, but when there is no Last year December month POC, it is showing as null value as shown in the above image;

Eg: 4.20-0= 4.20

3.80-0=3.80

How to fix this issue? attached is file for reference.

thanks

Bhavesh

pradosh_thakur — Wed, 13 Feb 2019 16:17:19 GMT

(Sum({<Cost_Code={8}>}POC)
-
alt(Above(TOTAL Sum({<MonthYear,Year,Cost_Code={8}>}POC), Num(Month)),0)
)

sunny_talwar — Wed, 13 Feb 2019 17:15:38 GMT

Or use RangeSum to add two numbers where one of them can be null()

RangeSum(Sum({<Cost_Code={8}>}POC),
-Above(TOTAL Sum({<MonthYear,Year,Cost_Code={8}>}POC), Num(Month)))

bhaveshp90 — Wed, 13 Feb 2019 17:05:46 GMT