Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bhaveshp90
Contributor III

How to resolve this error?

Hello,

I have a table a shown below;

1.PNG

I am calculating YTD as Current month - Baseline columns. But the yellow marked value is wrong (-32864-0 = -32864).

Why is my value showing as -? Any help

Tags (2)
1 Solution

Accepted Solutions

Re: How to resolve this error?

RangeSum(Current month, - Baseline)

5 Replies
Partner
Partner

Re: How to resolve this error?

hi

the problem is that the value is missing it's not zero

and you can't do a calculation with missing values

bhaveshp90
Contributor III

Re: How to resolve this error?

Yes it is missing, Is there a way to avoid it. even my expression If(Variance_YTD = ' ', 0, xxxxxxx) not working.

Re: How to resolve this error?

RangeSum(Current month, - Baseline)

bhaveshp90
Contributor III

Re: How to resolve this error?

thank you Marco, it worked like a charm.

bhaveshp90
Contributor III

Re: How to resolve this error?

We can also use if(isnull(field), 0, xxx).