Pivot Table shrinking when there is no value for perticular Month or Year

Gopi_E — Sat, 16 Nov 2024 00:32:09 GMT

Hi Qlikers,

I am facing a problem in pivot, i have a pivot table with Month and Year fields, but problem is when we select set of selections from diffrerent filters the table is not showing total months or years, because thos months or years dont have values, but my requirement is, if there is no values still we need to show all months.

Before Selection

I have used Show all values option in pivot , but it doesn't work for us,

please suggest any solution

Thanks in Advance.

Re: Pivot Table shrinking when there is no value for perticular Month or Year

Gopi_E — Fri, 05 Jun 2020 10:15:46 GMT

Hey All,

I got the solution,

We can use Only({1} ColorName()) this in to Dimension Background(Under Dimension press + you can see Background option) color, so basically if there is no value that cell will filled with color , here you can put whatever color.

Thank

Gopi

topic Pivot Table shrinking when there is no value for perticular Month or Year in QlikView

Pivot Table shrinking when there is no value for perticular Month or Year

Re: Pivot Table shrinking when there is no value for perticular Month or Year