Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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

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!

4 Replies

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

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.


talk is cheap, supply exceeds demand
Not applicable

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

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!

image_crosstab.jpg

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

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.


talk is cheap, supply exceeds demand
vijetasharma
Contributor III

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

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.

Community Browser