topic Re: Pivot table shrinkage issue in QlikView

Pivot table shrinkage issue

arpitkharkia — Wed, 04 Oct 2017 11:53:42 GMT

Hi all,

My original pivot table looks like this:

But after certain selections it shrinks to:

How to keep the table intact in its position?

PS- Bot the dimensions are calculate dimensions.

I know values are not present for other buckets thats why its shrinking but is it posible to show '0' or '-' for them and maintain a consistent look for the table?

Thanks in advance!

Re: Pivot table shrinkage issue

pradosh_thakur — Wed, 04 Oct 2017 12:06:37 GMT

without looking at the data it is hard to tell but

can you try and see if it works for you

in the presentation tab

1: un-check suppress zero value/missing value

2: change null symbols to '-' or '0'

regards

Pradosh

Re: Pivot table shrinkage issue

arpitkharkia — Wed, 04 Oct 2017 12:29:22 GMT

Hi Pradosh,

Yeah i know its difficult without data but i cant copy any data outside the the server. I tried those things in the presentation tab but no luck. Thanks for the help anyway!

Re: Pivot table shrinkage issue

prat1507 — Wed, 04 Oct 2017 15:13:16 GMT

Hi Arpit

Go into your dimension and change the background color to the only({1}white())

This will retain all your dimensions irrespective of any selections.

Regards
Pratyush

Re: Pivot table shrinkage issue

krishnacbe — Wed, 04 Oct 2017 15:32:36 GMT

Select "Show All Values" in both of your dimensions.

Re: Pivot table shrinkage issue

Gopi_E — Fri, 05 Jun 2020 09:56:02 GMT

Hi Arpit,

You can use below expression in dimension background, it will resolve your problem.

Only({1}White())

In pivote table dimentions background it will fill with color if there is no value for perticular fileds

Regards,

Gopi