Remove null values ​​hierarchy pivot table Qlik Sense

[jmialoundama]

Hi everyone, 

I created a hierarchy under Qlik Sense, this hierarchy with maximum 6 levels.

 I have nulls values ​​at certain levels of my hierarchy and I would like to remove them to make the visual side more beautiful.

I have unchecked the box "Include null values" in Qlik Sense but by checking this option in my 6 levels of dimensions, I lose data.

Is there a way to not include null values ​​without losing data ?

Thanks 🙂

[AshutoshBhumkar]

Hello,

Maybe you can replace those null with something like 'NA' or 'Others'. So that you won't need to remove null values from table.

Thanks,

Ashutosh

[Mateus]

I found a solution for my problem looking here:
https://community.qlik.com/t5/New-to-Qlik-Sense/Hide-empty-null-values-in-PivotTable/td-p/1721305