topic Re: How to resolve this error? in QlikView

How to resolve this error?

bhaveshp90 — Sat, 16 Nov 2024 04:56:10 GMT

Hello,

I have a table as shown below;

I have my expression as;

=If(Header_1 <> 'Curr.to OEC',
Rangesum(sum({<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),-2), 'YYYY-MM-DD'))"}>}POC_Adjusted_Value_USD)),

(

RangeSum(sum(TOTAL<Region, Month,  Country_Name, Snapshot_Date, Report_Param>{<Header_1 = {'Curr.mth.'}, Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date), -2), 'YYYY-MM-DD'))"}>}POC_Adjusted_Value_USD))
-
RangeSum(sum(TOTAL<Region,Month,Country_Name,Snapshot_Date,  Report_Param>{<Header_1 = {'Upd.OEC'}, Snapshot_Date = {">=$(=Date(Addmonths(Max({1}Snapshot_Date), -2),'YYYY-MM-DD'))"}>}POC_Adjusted_Value_USD))
)
)

This expression is working but when the values are same it is showing as null, look at the highlighted value in the image (182.378 - 182.378 = -)

Why is my value showing as - instead of '0'? any help is greatly appreciated.

thanks

Bhavesh

Re: How to resolve this error?

uacg0009 — Wed, 19 Dec 2018 02:38:40 GMT

Hi Bhaveshp,
It will be better if you can upload a small sample, so I can try to find out what the problem is.
Have you tried to add num() function for the rangesum()?
Aiolos

Re: How to resolve this error?

bhaveshp90 — Wed, 19 Dec 2018 03:09:56 GMT

@uacg0009 I have tried Num() also but I'm not getting '0'. Please see the attached qvw for your reference

Re: How to resolve this error?

uacg0009 — Wed, 19 Dec 2018 03:44:00 GMT

Hi,
I got the solution, in "Presentation" tab, there is "Suppress Zero-Values".
After you cancel it, you can see 0 values.
Aiolos

Re: How to resolve this error?

bhaveshp90 — Wed, 19 Dec 2018 13:54:51 GMT

thank you @uacg0009