How to get different colours for each member?

[#1]

Hi,

I have straight table with

Dimension1: StaffMember

Dimension2: Week

Expression1: =(Count({<[Result]={'Pass'}>} Distinct (ID))+Count({<[Result]={'Fail'}>} Distinct (ID)))

Expression2: Count({<[Result]={'Fail'}>} Distinct (ID))

Expression3: Count({<[Result]={'Fail'}>} Distinct (ID))/(Count({<[Result]={'Pass'}>} Distinct (ID))+Count({<[Result]={'Fail'}>} Distinct (ID)))

How can I change the colour of Dimension1 and Dimension2 so that each StaffMember with their corresponding Weeks should get different colours based on individual StaffMembers.

Thanks.

[arjunkrishnan]

Pls Let Attacht Ur Qvw...

Else

Write Expression On Your Background Color On ur Dimesion Wise

[#3]

you may define colors (RGB) and load it with your StaffMembers.

Then it will be easy to use those loaded values in charts.

Let me know if it helps or you need some example

regards

Darek

[#4]

Thanks. Can I have any example?

[#5]

Hi Amelia

Let me know if that helps!

regards

Darek

[#6]

Thanks. Actually I am getting data from excel. I need the colour change based on each Member.

[#7]

You can use the Background color and use ARGB or RGB function. Alternatively if you have only one Dimension then on the color tabs use the Multi colored check box

[#8]

Thanks. Found answer as

=if(StaffMember='Smith', yellow(),

if(StaffMember= 'Adam', rgb(255,228,225),

  if(StaffMember= 'Konan', green(), white())))

[#9 · Accepted solution]

Best approach is in QV Load statement create another column

=if(StaffMember='Smith', yellow(),

if(StaffMember= 'Adam', rgb(255,228,225),

  if(StaffMember= 'Konan', green(), white()))) as BG_Color

now in the Background color use the BG_Color this will be more optmized

[#10]

Thanks. That's really good.