pick match function

[andrea0901]

Hi Guys,

I have a requirement like this. i need to use different colors for each row.

Trans Type	Trans Type HL
ABC	Financial Transactions
DEF	Financial Transactions
XYZ	Financial Transactions
ERT	Financial Transactions
HJK	Non Financial Transactions
YUI	Non Financial Transactions
JKL	Non Financial Transactions
OPI	Non Financial Transactions

For example for Trans Type= ABC and Trans Type HL= Financial transactions the color should be Grey, and so on from other Trans Type 's as well. 

i tried doing using pick match but it is not working. i am using these colors  in donut chart. Please help me. 

[sunny_talwar]

Can you share the expression you have so far?

[andrea0901]

sure,

i have written like this below:

pick(match(Trans Type HL, 'Financial Transactions',

'ABC'.

'DEF',

'XYZ',

'ERT'),

RGB(219,0,17),RGB(123,123,123),RGB(123,456,678),RGB(876,123,123),

match(Trans Type HL, 'Non Financial Transactions',

'HJK',

'YUI',

'JKL'),

RGB(123,123,123),RGB(123,123,123),RGB(123,123,123)

)

[sunny_talwar]

May be try this?

Pick(Match([Trans Type]&'|'&[Trans Type HL],
'ABC|Financial Transactions',
'DEF|Financial Transactions',
'XYZ|Financial Transactions',
'ERT|Financial Transactions',
'HJK|Non Financial Transactions',
'YUI|Non Financial Transactions',
'JKL|Non Financial Transactions'),
RGB(219,0,17),
RGB(123,123,123),
RGB(123,456,678),
RGB(876,123,123),
RGB(123,123,123),
RGB(123,123,123),
RGB(123,123,123))

But if Trans Type will only be associated with a single Trans Type HL, why do you even need to have that in your pick match?

[andrea0901]

No i tried the above one, its not working. 

We are only giving colors to each Trans type. even i tried the below one. in the below code the first match function is working but not the second match function. 

pick(match(Trans Type , 

'ABC'.

'DEF',

'XYZ',

'ERT'

Trans Type HL, 'Financial Transactions'),

RGB(219,0,17),RGB(123,123,123),RGB(123,456,678),RGB(876,123,123),

match(Trans Type,

'HJK',

'YUI',

'JKL'

Trans Type HL, 'Non Financial Transactions'),

RGB(123,123,123),RGB(123,123,123),RGB(123,123,123)

)

[sunny_talwar · Accepted solution]

Seems to be working okay for me

[andrea0901]

yes, it is working. Thanks a lot Sunny.