Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Well, you need to change the condition in the IF statement. For example:
IF(Dimension='member1' or Dimension='member2', Red())
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.
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
go to dimension-> click on + sign befor dimension you want to color
background-> =Red()
hope this helps
Check out this application and follow the instructions above.
hi
thanks for ur reply,its not working.ia any other way to do this...
regards,
ba
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.
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
Well, you need to change the condition in the IF statement. For example:
IF(Dimension='member1' or Dimension='member2', Red())
Thankyou very much qlikuser14, it is working insted of 'or' i am taking 'and'.
regards, ba