Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Tanviseth26
New Contributor

Pivot Drill Down stop at the level before null level but dosen’t exlcude the amt in the grand total

Hi,

In qliksense pivot table is there any way to stop Drill Down at the level before null level but dosen’t exlcude the amont in the grand total?

 

2 Replies
Highlighted
Employee
Employee

Re: Pivot Drill Down stop at the level before null level but dosen’t exlcude the amt in the grand to

Could you elaborate a bit more about your question? not so sure I´m getting your problem
Tanviseth26
New Contributor

Re: Pivot Drill Down stop at the level before null level but dosen’t exlcude the amt in the grand to

Hi Cuv,

I am talking about the ragged hierarchy where some data will be missing. I want to plot that data in a pivot table where if there will be any level missing , that should not be shown in the table but the value w.r.t that particualar level should be added to the total above it.