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

[suvechha_b]

I got the attachedment....

but the thing is.....I tried the same expression but....still it not working....

is there any other reason???

[kaushiknsolanki]

Hi,

     Did you check in the attachment.

     Is it showing the same which you want?

     If yes then it should work.

Regards,

Kaushik Solanki

[suvechha_b]

yes...the attachment is correct....which want...

but it is not working at my qlikview model....

[kaushiknsolanki]

Hi,

     Check you must be missing something in expression.

Regards,

Kaushik Solanki

[suvechha_b]

when I copy you sheet in my model....

and want to change the color....it is not working .....