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.

[#2]

Amelia,

Amit solution will work well.

But what if you hire new persons?

You will have to change your expression.

This is why it may be better (if your dimension is not staic) load color definitions from external source (for example excel or some database).

Have fun with QV

regards

Darek

[josephinetedesc]

Hi All

I am so close but ..

I have two files: one spreadsheet with name, records sold,

another spreadsheet with name, num fans.

another spreadsheet so that John's values in a chart are always shown as red., Paul's values as blue and George as green.

Could you show me a QlkView file how this is done please.

,