topic Re: Please help...it is not working in QlikView

Please help...it is not working

suvechha_b — Mon, 15 Jul 2013 08:33:27 GMT

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)

=if(Odd(min(TOTAL <=$(vMonthYr)>=$(vMonthYr))),rgb(255,123,230),rgb(122,123,255))

but it is not working ....

Re: Please help...it is not working

kaushiknsolanki — Mon, 15 Jul 2013 08:35:39 GMT

Hi,

Post your qvw file.

Regards,

Kaushik Solanki

Re: Please help...it is not working

luciancotea — Mon, 15 Jul 2013 08:43:08 GMT

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

Re: Please help...it is not working

kaushiknsolanki — Mon, 15 Jul 2013 08:59:03 GMT

Hi,

Try this.

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

Regards,

Kaushik Solanki

Re: Please help...it is not working

suvechha_b — Mon, 15 Jul 2013 09:05:21 GMT

no still its not working....

Re: Please help...it is not working

Gysbert_Wassenaar — Mon, 15 Jul 2013 09:05:35 GMT

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

Re: Please help...it is not working

kaushiknsolanki — Mon, 15 Jul 2013 09:07:42 GMT

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

Re: Please help...it is not working

suvechha_b — Mon, 15 Jul 2013 09:13:27 GMT

did I have to change any other settings???

I did the same thing....

den why it is not coming?

Re: Please help...it is not working

suvechha_b — Mon, 15 Jul 2013 09:14:50 GMT

one header will do for now...

Re: Please help...it is not working

kaushiknsolanki — Mon, 15 Jul 2013 09:19:43 GMT

Hi,

Have a look at the attachment.

Regards,

Kaushik Solanki

Re: Please help...it is not working

suvechha_b — Mon, 15 Jul 2013 09:29:39 GMT

I got the attachedment....

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

is there any other reason???

Re: Please help...it is not working

kaushiknsolanki — Mon, 15 Jul 2013 09:32:03 GMT

Hi,

Did you check in the attachment.

Is it showing the same which you want?

If yes then it should work.

Regards,

Kaushik Solanki

Re: Please help...it is not working

suvechha_b — Mon, 15 Jul 2013 09:35:03 GMT

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

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

Re: Please help...it is not working

kaushiknsolanki — Mon, 15 Jul 2013 09:36:38 GMT

Hi,

Check you must be missing something in expression.

Regards,

Kaushik Solanki

Re: Please help...it is not working

suvechha_b — Mon, 15 Jul 2013 11:05:23 GMT

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

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