Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sujit_nath
Creator II
Creator II

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 (2)
2 Replies
sujit_nath
Creator II
Creator II
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