Set bar chart colors (data from crosstable)

[ben0109]

Hi

I have a bar chart that is generated from a crosstable and need to change the colors. The data is as follows:

Sum({$<[Income Type]={'YTD Total Income'}>} [Income Value])

Sum({$<[Income Type]={'Prior year actual'}>} [Income Value])

Sum({$<[Income Type]={'Budget'}>} [Income Value])

I have tried the following to change the colors, without any success - I only get a light grey color.

=Pick(Match([Income Type], '[Income Type]={"Budget"}', '[Income Type]={"Prior Year Actual"}', '[Income Type]={"YTD Total Income"}'),rgb(73,78,84),rgb(215,210,202),rgb(158,145,111))

=if([Income Type]='Budget',rgb(73,78,84),if([Income Type]='Prior Year Actual',rgb(73,78,84),if([Income Type]='YTD Total Income',rgb(158,145,111))))

Thank you

Ben

[Anil_Babu_Samineni]

Perhaps this?

=Pick(Match([Income Type], 'Budget', 'Prior Year Actual', 'YTD Total Income'),rgb(73,78,84),rgb(215,210,202),rgb(158,145,111))

[ben0109]

Hi,

I tried this, but it still shows a light grey color. I thought that it may only read one color, so tried changing it to more distinct RGB colors (255,0,0), etc. but still no luck.

[ben0109 · Accepted solution]

I go the answer by adding the chart's measures as Master Item Measures and selecting the color there.

To apply, https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Colors/assigning-col...