Unable to create Non Additive Hierarchy in Qliksense

[Anonymous]

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.

[Anonymous]

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

Thanks!

[Anonymous]

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]

could you please post some sample data?

[Anonymous]

Hi Krishna,

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

Thanks!

[Anonymous]

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!