topic Re: How to remove dash in the pivot table when using hierarchy function to generate the parent-child relationship in App Development https://community.qlik.com/t5/App-Development/How-to-remove-dash-in-the-pivot-table-when-using-hierarchy/m-p/1950970#M78371 <P>can you post the expression you used</P> Sat, 02 Jul 2022 05:12:29 GMT vinieme12 2022-07-02T05:12:29Z How to remove dash in the pivot table when using hierarchy function to generate the parent-child relationship https://community.qlik.com/t5/App-Development/How-to-remove-dash-in-the-pivot-table-when-using-hierarchy/m-p/1950692#M78336 <P>Hi Team,</P> <P>I am using hierarchy function in the script to generate the parent-child relationship.<BR />Parent can have multiple children and child can have further child and so on.</P> <P>I want to show this in the pivot table. But I am getting hyphen(-) where there is no subchild for the parent.</P> <P>Any help on this is much appreciated.</P> <P>Attached are the screenshots.</P> Fri, 01 Jul 2022 10:43:28 GMT https://community.qlik.com/t5/App-Development/How-to-remove-dash-in-the-pivot-table-when-using-hierarchy/m-p/1950692#M78336 AparnaRS 2022-07-01T10:43:28Z Re: How to remove dash in the pivot table when using hierarchy function to generate the parent-child relationship https://community.qlik.com/t5/App-Development/How-to-remove-dash-in-the-pivot-table-when-using-hierarchy/m-p/1950970#M78371 <P>can you post the expression you used</P> Sat, 02 Jul 2022 05:12:29 GMT https://community.qlik.com/t5/App-Development/How-to-remove-dash-in-the-pivot-table-when-using-hierarchy/m-p/1950970#M78371 vinieme12 2022-07-02T05:12:29Z