Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello world!
Somehow i cant have 2 or more fields with unticked "include null values" at the same time, the fields by default have "include null values".
Null values show up when "include null values" is ticked.
When i untick one field, all the rows show
Now all the rows disappear when i untick the last two fields
"Include null values" applies to the individual dimension you've ticked or unticked it for. It does not check across multiple dimensions.
Thank you for your reply, why do all rows disappear, is there a way to fix this issue?
If you do not include null values in a dimension, then rows with that dimension having a null value will be hidden. If you don't want them hidden, include the null values.
If you're looking to hide only rows where a certain combination of values is null, you should add a measure checking for the combination required and then uncheck "Include zero values" at the chart level.
I am not creating a chart at all, only table. Thats the issue. All these fields are dimensions.
A table is a type of chart (in Qlik parlance, anyway). This is not an issue. Adding a measure should not be a problem (but you could also add a calculated dimension if you prefer).