Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hide rows in Pivot Table

I want the hide rows in pivot able if exp3 is equal to zero

My Exp3 is substraction of Exp1-Exp2

I have table like this

Dimension       Exp1     Exp2     Exp3  (Exp1-Exp2)

A                     300        100        200

B                    100           50          50

C                    100        100             0

My result should be like this.

Dimension       Exp1     Exp2     Exp3 

A                     300        100        200

B                    100           50          50

Please help me to fix the issue.

2 Replies
MayilVahanan

Hi

You need to include the expression in all the three expression and tick the suppress zero values options.

Exp1:

=if(Column(3) <> 0, Exp1) or If( (Exp1-Exp2) <> 0, Exp1)

similarly to exp2.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

Make Exp1 & Exp2 dimensiosns and just have a single expression, see attached.