topic How to handle null values when we load a cross table in Qlik Sense? in App Development

How to handle null values when we load a cross table in Qlik Sense?

Thu, 14 Jul 2016 06:13:41 GMT

Hello,

I would like how to handle null values when we load a cross table in Qlik Sense. In the parameters file, we insered:

NullAsValue *;

SET NullValue=0;

but it's not enogh.

Thank you for your answer!

Re: How to handle null values when we load a cross table in Qlik Sense?

Gysbert_Wassenaar — Thu, 14 Jul 2016 08:50:48 GMT

Can you explain what you're trying to do and what the problem is? A small qlik sense app that demonstrates the problem would be helpful.

Re: How to handle null values when we load a cross table in Qlik Sense?

Fri, 15 Jul 2016 09:22:38 GMT

Hello,

You can find an image attached. We would like to have 0 as default and not '-', when elements don't exist in a cross tab.

Thanks for your reply!

Re: How to handle null values when we load a cross table in Qlik Sense?

Gysbert_Wassenaar — Fri, 15 Jul 2016 10:06:04 GMT

That's not possible. There's no setting for that yet. If you want 0 instead of '-' then you need to generate data for all the combinations of dimension values in the script.

Re: How to handle null values when we load a cross table in Qlik Sense?

vijetas42 — Mon, 24 Oct 2016 08:58:00 GMT

Hi,

I am using crosstable load in qliksense and want ti put null as 0 values as swhown in below code,

NullAsValue *;

SET NullValue = 0;

Temp:

CrossTable(Flag, Data, 71)

LOAD * FROM

[lib://AttachedFiles/abc.qvd]

(qvd);

but it's not working.

can you please help for the same.