Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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
Author

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

Gysbert_Wassenaar

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
vijetas42
Specialist
Specialist

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.