Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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

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 SelectionBefore Selection

Inked178586_Delete1_L2.jpg

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

please suggest any solution 

Thanks in Advance.

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

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

View solution in original post

1 Reply
Highlighted
Creator II
Creator II

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

View solution in original post