Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Tanviseth26
Not applicable

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
Clever_Anjos
Not applicable

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
Not applicable

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.