topic Re: Convert NULL to 0 in QlikView

Convert NULL to 0

stabben23 — Thu, 18 Apr 2013 10:26:08 GMT

Hi,

I have no sales for an Item in a month, sum(amount) and try to compare it with a Budget in a straight table. The Budget has a value but wont show up in my table because sales in NULL. The Budget is concatenated into the sales. How to solve this in an easy way?

Re: Convert NULL to 0

kaushiknsolanki — Thu, 18 Apr 2013 13:31:30 GMT

Hi,

There are ways, but this depends on how you are linking the budget with your data.

It will be helpful if you post some sample example.

Regards,

Kaushik Solanki