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: 
sujit_nath
Creator III
Creator III

Hide columns in pivot table

I have a pivot table with 3 expressions budget, spend and difference. difference being spend-budget.

There are plans such that budget is allocated, but spend data is not available. Now I want the chart to be displayed in such a way that, if the spend data is not available, do not show the spend and difference.

Capture.PNG

That means for Plan3, I will only see budget column and not spend and difference. How do I achieve that.

Labels (1)
2 Replies
sujit_nath
Creator III
Creator III
Author

Basically I want to hide the expression column if the values are null.

jj_kobalt
Contributor
Contributor

Did you already found a solution for this? Looking at the same problem