Discussion board where members can get started with Qlik Sense.
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.
Sorry for writing here again, but I would really appreciate any help.
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?
could you please post some sample data?
I have attached the sample data(Hierarchy_data.xlsx).
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.