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.