Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I change the color a column of the current month of the year?
I want to change the color of column Jul 2013 with green or any other color.
Please note Jul 2013 field is dimension .
and I have used variable vMonthYr
and I used inline sorting like this :
MonthSort1:
Load * inline [
fiscal_period,SortOrder1
7,Jan
8,Feb
9,Mar
10,Apr
11,May
12,Jun
1,Jul
2,Aug
3,Sep
4,Oct
5,Nov
6,Dec
];
for the output:
Jul 2013, Aug 2013,...Dec 2013, Jul 2014, Aug 2014....Dec 2014
I had tried on the background color this one:
=if(vMonthYr='Jul', rgb(255,0,0), rgb(0,0,255)
OR
=if(Odd(min(TOTAL <=$(vMonthYr)>=$(vMonthYr))),rgb(255,123,230),rgb(122,123,255))
but it is not working ....
Hi,
Post your qvw file.
Regards,
Kaushik Solanki
in Dimensions tab, click the + sign next to "MonthYear" dimension and add this in the "Background Color" expression:
=if( InMonth( Today(), [MonthYear], 0), rgb(255,0,0), rgb(0,0,255))
Hi,
Try this.
=if( WildMatch([Fiscal Month],'Aug'),Red(),Yellow())
Regards,
Kaushik Solanki
no still its not working....
Try =if([Fiscal Month]= Month(Today()), rgb(255,0,0), rgb(0,0,255)). See attached file
Hi,
It is working at my side.
Do you need the colors to only Headers or the full columns?
If you need for full columns then try the same expression in the expression tab.
Regards,
Kaushik Solanki
did I have to change any other settings???
I did the same thing....
den why it is not coming?
one header will do for now...
Hi,
Have a look at the attachment.
Regards,
Kaushik Solanki