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

[Gopi_E]

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.

[Gopi_E · Accepted solution]

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