New to Qlik Analytics

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

Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

Who Me Too'd this topic

jmialoundama
Specialist
Specialist

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 (3)
Who Me Too'd this topic