Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

QlikView

Announcements
Data Works for AI is here - Join the discussion and enter to win a pair of Qlik kicks: Join the Conversation!

Who Me Too'd this topic

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 (2)
Who Me Too'd this topic