Discussion Board for collaboration related to Qlik Education.
I have pivot as below
Country State Sales
USA NJ -
Country and State are dimension and Population is expression.
Now when no sales for all the States, still I want to see pivot chart as above with value 0 for Sales, rather than shrinked.
Is there any way. I appreciate your help
Go to Solution.
In order to show zero values in a pivot table, you need to do the following:
1. Show All Values for ALL the dimensions in the Dimension tab
2. Clear the Suppress zero Values from the Presentation tab.
Check the attached qvw.
Let me know if this works for you and if you need anything else :-)
Uncheck 'Suppress Zero Values' on the presentation tab.
It works but dimension are missing. This is just example but in my case there 100s of lines and I need to see all those even zero values.
Thanks for your great help
I appreciate your efforts, I do not see any attachment here.
Please attach again,
Is this what you wanted Satish? Is there anything else I can do to help you?
Could you please mark the answer as Correct if this is what you were looking for?
Sorry for late, your suggestion works perfectly.
I appreciate your interest and time