Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

alex_stone
Contributor

How to show missing dimension in pivot table

Currently, we have a pivot table, it will show all dimension value when all has value.

Some dimension value will hide after we select period time.

e.g.

Dimension 1 asset risk: High, Medium, Low

Dimension 2 client risk: High, Medium, Low

Table format:

Client Risk   High     Medium     Low

Asset Risk

High               3        6              4     

Medium          4        7              2

Low               5         8              7

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

It will be shown as below after select period time

Client Risk      Medium     Low

Asset Risk

High               6              4     

Medium         7              2

Low               8              7

My problem is, how to show null value or missing value for Client Risk dimension. And want to show it as below after select period time.

Client Risk   High     Medium     Low

Asset Risk

High               0        6              4     

Medium          0        7              2

Low                0         8              7

Is there any approach to solve above problem?

Tags (1)
3 Replies

Re: How to show missing dimension in pivot table

Disable the Suppress Zero Values and Suppress Missing options on the presentation tab and enable the Show All Values option for the dimensions.


talk is cheap, supply exceeds demand
alex_stone
Contributor

Re: How to show missing dimension in pivot table

Yes, we use above approach to reach my requirement. Thank you for your attention.

Re: How to show missing dimension in pivot table

Would you mind marking this discussion as answered?


talk is cheap, supply exceeds demand
Community Browser