Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
amanjain57
Creator II
Creator II

How can I stop total for one columns of Pivot Table ?

Hello, 

I have a pivot table that has few columns. I added the total column that by default adds all the columns. 

But i want to stop it to add for one column. 

you can see the example below. 

clipboard_image_0.png

I have to stop the addition for Block Stock (the last line). 

Thanks 

Aman

Labels (1)
2 Replies
StarinieriG
Partner
Partner

Hi,

maybe try with

If(Dimensionality()<>0 or yourdimension<>the value that you want without total, yourexpression, ' ')

amanjain57
Creator II
Creator II
Author

Thanks for the reply, I tried this solution but in this case all the columns go blank. I just want Totals to go Blank