Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I have used Show all values option in pivot , but it doesn't work for us,
please suggest any solution
Thanks in Advance.
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
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