Pivot Table Null values handling in Measures and Dimensions

Srinivasulu Thottempudi

started a topic 7 months ago

Hi Team,

How to handle Pivot Table Null values handling in Measures expressions and Dimensions Expressions?

Empty Rows are also showing in Dimensions Row like '-'and Columns also.

Regards,

Srinivas

Daniel Adesanya
said 3 months ago

Hiya,

Handling Null values would be similar to that of a Qlik native Pivot Table.

You can have the 'Include Null value' unchecked if you don't want to have the null values brought into your table

You can test it by creating a Qlik native chart with the same dimensions/measures to check the display.