Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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!
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.
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.