Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
mapratt82
Creator
Creator

Hiearchy with Varible Levels

I have a table that has AcctNum, AcctName, and ParentAcctNum in it. I need to set up a hiearchy for it in a pivot table along with a hiearchy filter. There are 4 top level parent accounts, however the level for each varies from 2-6 total levels depending on the parent acct. I'm getting more than a few null values that I can't seem to get rid of, if I uncheck Show Null Values, then once I expand past the max level for a parent account it disappears. I have also tried unchecking the Show Zero Values box also. I also need to get rid of all the nulls from each level. I'm currently using the Hiearchy function with defaults. Thanks in advance for any help or advice!

Labels (2)
1 Reply
Channa
Specialist III
Specialist III

is it possible to share similar data

Channa