topic Re: Show All Dimension Values In Pivot Table in QlikView

Show All Dimension Values In Pivot Table

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

My pivot table has three dimensions:

Hours
VName
Answered_Abandoned

And two expressions:

Volume: TextCount (session_id)
Delay: Max(duration)

And here is how it looks.

How do I show all Hours for all VName? I have went through few posts, includes the ones below but I could not figure out. Any inputs are appreciated.

Show all dimensions in a pivot

Show all values in Pivot/Straight Table (irrespective of current selection)

Show all values in a dimension

Thanks all.

Re: Show All Dimension Values In Pivot Table

tamilarasu — Thu, 14 Apr 2016 07:09:19 GMT

Hi Phong,

Just check "Show all values" in dimensions tab.

Re: Show All Dimension Values In Pivot Table

Chanty4u — Thu, 14 Apr 2016 08:05:02 GMT

select ur dimension and chk the

option "Show All values"

Re: Show All Dimension Values In Pivot Table

Thu, 14 Apr 2016 12:53:13 GMT

I tried the Show All Values but it did not do anything, still the same.

Re: Show All Dimension Values In Pivot Table

sunny_talwar — Thu, 14 Apr 2016 13:01:16 GMT

Do you have a sample you can share?

Re: Show All Dimension Values In Pivot Table

syukyo_zhu — Thu, 14 Apr 2016 13:09:47 GMT

Hi,

try this disable option "suppress zero -value"

Re: Show All Dimension Values In Pivot Table

Thu, 14 Apr 2016 13:32:37 GMT

Hi,

Thank you for your response but it's still not working. I think I need to somehow force Qlikview to add zeros to the combined dimension values and show everything but I just don't know how to update my expressions.

Re: Show All Dimension Values In Pivot Table

Thu, 14 Apr 2016 13:32:59 GMT

I will working on the sample and provide.

Re: Show All Dimension Values In Pivot Table

stabben23 — Thu, 14 Apr 2016 13:40:42 GMT

Do you really have transactions for all times on Abandoned in Your report?

Re: Show All Dimension Values In Pivot Table

Thu, 14 Apr 2016 13:53:19 GMT

No, I do not. In fact, VNames don't have all the hours, but I want to force it to show all the hours for each VNname.