Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mansi_1234
New Contributor

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.

Tags (2)
5 Replies
mansi_1234
New Contributor

Re: Unable to create Non Additive Hierarchy in Qliksense

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

Thanks!

rmp001es
New Contributor II

Re: Unable to create Non Additive Hierarchy in Qliksense

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
Valued Contributor III

Re: Unable to create Non Additive Hierarchy in Qliksense

could you please post some sample data?

mansi_1234
New Contributor

Re: Unable to create Non Additive Hierarchy in Qliksense

Hi Krishna,

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

Thanks!

mansi_1234
New Contributor

Re: Unable to create Non Additive Hierarchy in Qliksense

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!

Community Browser