Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to create Non Additive Hierarchy in Qliksense

Hi All,

I am trying to create a non additive hierarchy (Parent-Child relationship) by using Pivot table in Qliksense. I have used no aggregation in measure.

I can see dashes at each level though such data is not present.

In order to remove the dashes, when I untick  'Include Null Values' , then the nodes with no child nodes gets vanished.

Please suggest how to make such hierarchy.

The screen shots are as attached.

5 Replies
Anonymous
Not applicable
Author

Sorry for writing here again, but I would really appreciate any help.

Thanks!

Anonymous
Not applicable
Author

Hi,

In the Link table that you have there are more data for which you can have null values ​​or only have the hierarchy and the date? I ask because it may be the case or do you only have that data?

krishna_2644
Specialist III
Specialist III

could you please post some sample data?

Anonymous
Not applicable
Author

Hi Krishna,

I have attached the sample data(Hierarchy_data.xlsx).

Thanks!

Anonymous
Not applicable
Author

Hi Raquel,

There is no link table created separately.

I have attached the excel used. I used the sheet 'Hierarchy' with HIERARCHY function in qliksense.

Then joined that with the values in 'Data' sheet.

Thanks!