topic Re: Re: Display Pivot when no values in Qlik Learning Discussions

Display Pivot when no values

Anonymous — Thu, 02 Oct 2014 14:43:22 GMT

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

Re: Display Pivot when no values

jonathandienst — Thu, 02 Oct 2014 14:47:45 GMT

Uncheck 'Suppress Zero Values' on the presentation tab.

HTH

Jonathan

Re: Display Pivot when no values

Anonymous — Mon, 06 Oct 2014 17:59:23 GMT

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

Re: Re: Display Pivot when no values

Agis-Kalogiannis — Mon, 06 Oct 2014 20:07:27 GMT

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

Re: Re: Display Pivot when no values

Anonymous — Fri, 10 Oct 2014 18:05:25 GMT

Hi Agis

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

Please attach again,

Thanks

Re: Re: Re: Display Pivot when no values

Agis-Kalogiannis — Sun, 12 Oct 2014 19:35:02 GMT

Now???

Re: Display Pivot when no values

Agis-Kalogiannis — Wed, 15 Oct 2014 08:05:05 GMT

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

Re: Display Pivot when no values

Anonymous — Mon, 27 Oct 2014 21:41:22 GMT

Hi Agis

Sorry for late, your suggestion works perfectly.

I appreciate your interest and time

Thanks

Satish