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

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!