IF & SUM with colour

[TomBond77]

Hi experts

I need to create for the following condition a sum KPI in a bar chart. The KPI elements should have different colours. The sum(amount) must be included. Any ideas?

=if([Text]='Due 1 - 30 days', '#a54343', if([Text]='Due 31 - 60 days', '#26a0a7'))

[Vegar]

You need to converting your colors into RGB() or any other color format that Qlik Sense objects understand. Then you can look at this page for help on how to control which color to pick per bar: https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Colors/color-by-expr...