Please help...it is not working

[suvechha_b]

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 ....

[kaushiknsolanki]

Hi,

     Post your qvw file.

Regards,

Kaushik Solanki

[luciancotea]

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))

[kaushiknsolanki]

Hi,

     Try this.

     =if( WildMatch([Fiscal Month],'Aug'),Red(),Yellow())

Regards,

Kaushik Solanki

[suvechha_b]

no still its not working....

[Gysbert_Wassenaar]

Try =if([Fiscal Month]= Month(Today()), rgb(255,0,0), rgb(0,0,255)). See attached file

[kaushiknsolanki]

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

[suvechha_b]

did I have to change any other settings???

I did the same thing....

den why it is not coming?

[suvechha_b]

one header will do for now...

[kaushiknsolanki]

Hi,

     Have a look at the attachment.

Regards,

Kaushik Solanki