I would like how to handle null values when we load a cross table in Qlik Sense. In the parameters file, we insered:
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.
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.
I am using crosstable load in qliksense and want ti put null as 0 values as swhown in below code,
SET NullValue = 0;
CrossTable(Flag, Data, 71)
LOAD * FROM
but it's not working.
can you please help for the same.
Retrieving data ...