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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Delete or don't show single rows of a pivot table.

HI,

I have a problem with a pivot table.In this pivot table I have an Expression that calculates the difference beetween two values and that are calculated with other expressions in the same table; I want that when this difference is 0 then the intire row has to vanish from the pivot table,all this without modifing the sql script.

Hoping in an aswer,

Dominic

1 Reply
Not applicable
Author

I've got the solution just adding an if to all the expressions of the table that sets their value to 0 if the difference is 0 and checking the flag Suppress Zero Values in the tab Graph of table properties!