Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Tanviseth26
Contributor
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
Clever_Anjos
Employee
Employee

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

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.