I have few expressions in the pivot table but i don't want to show the values of all. I just need a way to hide the expression and i can use that hidden expression column in calculating another expression. Find the attachment for the example. How can i hide an expression in pivot table but still use in calculating another expression?
Exp1
(hidden)
Exp2
(hidden)
Exp3=Column(2)-Column(1)
The way i am trying to do this is for the expression(Exp3) using the columns from previous expressions which should be hidden.
one way is that you can make the background color and text color of the expression the same and make that column as small as possible...just like Sudeep showed. I guess we were typing at the same time!
in the above scenario if i am in your place i would create a straight table with the above solution given by Sundeep or else create variables for exp1 and exp2 and use them in the exp3 so you don't need to worry to hide them.
2nd You can create a variable in that save your expression.
and use that variable in your pivot table.
try this.
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
I think the closest i can get with this requirement is what Sudeep Mahapatra proposed. But, still to dreamer4 point creating a variable and using that in the expression is always an option. For me i would go with the first one.
I thought this would be helpful to share to anyone who will come across the same situation. So, if you try to implement by making the background color and text color similar which in this case you can almost make the column values invisible but when the user tries to export the pivot table to excel then the values of the column does show up in that case this might not be a idle solution. I hope there is a better way to do this.
Goto Chart properties select Pivot table in general-> Expression->Check Conditional, then below box gets activated. just give the condition else type 1=2.
