Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Hide Parent /child rows in pivot table - Qliksense

Hi All,

I have a pivot table ( as shown below).  I have 2 questions.

1. how can I hide a row if I have only one child value (in case of Core Adj: G&A). In this case, I want to hide the child row (as it is repeated) 

Pivot table.PNG


2. when I drill down to same parent value (Core Adj: G&A), I am getting multiple repeated rows (please refer below image)

I want to show only the child row (here in this case it is others.) and want to hide all parent rows ( as again values are repeated and not looking good)

Drill - Pivot table.PNG

Could any one suggest me how to achieve this, please .




Labels (1)
0 Replies