Need colour for single field and row in expression

[#1]

Hi,

My requirement is to give the colour for only one field in dimension and with their related expression.

can anyone know about this thing pls let me know.

regards,

ba

[jvitantonio]

hI,

Go to the Dimensions Tab, expand the dimension you want to color out, double click on Backgourp Color and write and if statement:

IF(YourDimension='YourValue', RED())

Then go to the expresion tab, select Backgroup color for the formula you want to color out, and paste the same formula as above.

[#3]

Hello Qlikuser14,

Thanks for ur reply,can u pls explain me in detail i am new to qlikview.sorry for trouble.

thanks a lot

ba

[SunilChauhan]

go to dimension-> click on + sign befor dimension you want to color

background-> =Red()

hope this helps

[jvitantonio]

Check out this application and follow the instructions above.

[#6]

hi

thanks for ur reply,its not working.ia any other way to do this...

regards,

ba

[jvitantonio]

Barul IT IS working as shown in the application. If this is not what you need the you should be more specific with what you need and give a real example of your situation.

[#8]

Hi Qlikuser14,

I am sorry for trouble again,it is working.fine but i want to displaythe same colour for another field,it is also same dimension.when i am trying this but it is displaying white colour.

you have any idea about this.

regards,

ba

[jvitantonio · Accepted solution]

Well, you need to change the condition in the IF statement. For example:

IF(Dimension='member1' or Dimension='member2', Red())

[#10]

Thankyou very much qlikuser14, it is working insted of 'or' i am taking 'and'.

regards, ba