Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display Pivot when no values

Hi all

I have pivot as below

Country    State    Sales

USA          NJ           -

                 CT          -

                 DE          -

                 DC          -

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

Thanks

1 Solution

Accepted Solutions
Agis-Kalogiannis
Employee
Employee

Hi Satish

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 🙂

Regards

Agis

View solution in original post

7 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Uncheck 'Suppress Zero Values' on the presentation tab.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Hi Jonathan

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

Agis-Kalogiannis
Employee
Employee

Hi Satish

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 🙂

Regards

Agis

Anonymous
Not applicable
Author

Hi Agis

I appreciate your efforts, I do not see any attachment here.

Please attach again,

Thanks


Agis-Kalogiannis
Employee
Employee

Now???

Agis-Kalogiannis
Employee
Employee

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?

Thanks

Agis

Anonymous
Not applicable
Author

Hi Agis

Sorry for late, your suggestion works perfectly.

I appreciate your interest and time

Thanks

Satish