Show All Dimension Values In Pivot Table

[#1]

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.

[tamilarasu]

Hi Phong,

Just check "Show all values" in dimensions tab.

[Chanty4u]

select ur dimension and  chk the 

option  "Show All values"

[#4]

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

[sunny_talwar]

Do you have a sample you can share?

[syukyo_zhu]

Hi,

try this disable option "suppress zero -value"

[#7]

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.

[#8]

I will working on the sample and provide.

[stabben23]

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

[#10]

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.