Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Creator III
Creator III

Remove null values ​​hierarchy pivot table Qlik Sense

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 🙂

Labels (4)
2 Replies
AshutoshBhumkar
Partner
Partner

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
Partner
Partner