topic Non Additive Hierarchy in qliksense in App Development https://community.qlik.com/t5/App-Development/Non-Additive-Hierarchy-in-qliksense/m-p/19251#M1289 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi All,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">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.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I can see dashes at each level though such data is not present.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">In order to remove the dashes, when I untick&nbsp; 'Include Null Values' , then the nodes with no child nodes gets vanished.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please suggest how to make such hierarchy.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">The screen shots are as attached.</P></BODY></HTML> Tue, 27 Feb 2018 13:02:35 GMT Anonymous 2018-02-27T13:02:35Z Non Additive Hierarchy in qliksense https://community.qlik.com/t5/App-Development/Non-Additive-Hierarchy-in-qliksense/m-p/19251#M1289 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi All,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">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.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I can see dashes at each level though such data is not present.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">In order to remove the dashes, when I untick&nbsp; 'Include Null Values' , then the nodes with no child nodes gets vanished.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please suggest how to make such hierarchy.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">The screen shots are as attached.</P></BODY></HTML> Tue, 27 Feb 2018 13:02:35 GMT https://community.qlik.com/t5/App-Development/Non-Additive-Hierarchy-in-qliksense/m-p/19251#M1289 Anonymous 2018-02-27T13:02:35Z