Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

satishkamath
Contributor II

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
Employee
Employee

Re: Re: Display Pivot when no values

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

7 Replies
MVP
MVP

Re: Display Pivot when no values

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
satishkamath
Contributor II

Re: Display Pivot when no values

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

Employee
Employee

Re: Re: Display Pivot when no values

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

satishkamath
Contributor II

Re: Re: Display Pivot when no values

Hi Agis

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

Please attach again,

Thanks


Employee
Employee

Re: Re: Re: Display Pivot when no values

Now???

Employee
Employee

Re: Display Pivot when no values

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

satishkamath
Contributor II

Re: Display Pivot when no values

Hi Agis

Sorry for late, your suggestion works perfectly.

I appreciate your interest and time

Thanks

Satish

Community Browser