Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide pivot table row

Hello everyone, I need to know if it is possible in a pivoting table to hide the rows that result in "0".

As you see in the picture the total column, hide the results that are in "0"Ocultar 0.bmp

9 Replies
Anonymous
Not applicable
Author

Try this:

ocultar zero.JPG

Not applicable
Author

Good friend

Make that option that you mention but same follows the "0".

Di.bmp

rupamjyotidas
Specialist
Specialist

In calculated dimension

=If(aggr(Sum(YourEqaution),Art)>0,Art)

Not applicable
Author

Good friend

I attached the file so I can receive help from you, thank you.

Not applicable
Author

Good friend

Please send me your emails to attach the file since I do not know how to do it by this means.

Anil_Babu_Samineni

Upload Community by guide from below link so that every one can understand

Uploading a Sample

OR You may use this

anilbabu.qlikview@gmail.com

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Properties--> Presentation tab--> select suppress zero.pngzero-values

Anonymous
Not applicable
Author

Try this:

dimensao.JPG

Not applicable
Author

In calculated dimension use below

If(Count(ID)>0,your dimension)

use your expression and dimension