Mekko chart - Drill-down dimension custom colors applied

[Tetry]

Hi all,

I am trying to set custom colors for a drill down dimension and apply it on a Mekko chart.

I am using the following expression in the expression editor, after having selected custom colors from the mekko chart menu.

=if(isnull(GetFieldSelections(IFRS_Portfolio)),
Pick((Match(only({<reporting_date={'31/12/2021','31/12/2020'}>}IFRS_Portfolio), 'Wholesale', 'Retail', 'Public Sector')), RGB(0,0,0), RGB(255,255,255), RGB(26, 188, 156)),
Pick((Match(only({<reporting_date={'31/12/2021','31/12/2020'}>}IFRS_AssetClass), 'Mortgages', 'Consumer', 'SB','SMEs','Large Corporate','Public')), RGB(0,0,0), RGB(68,119,170), RGB(26, 188, 156), RGB(204,102,119), RGB(68,119,170), RGB(26, 188, 156))
)

Is it possible that the Mekko chart does not support custom colors by expression?

I was able to make this work in other charts, eg grid chart.

Thank you

I am using Qlik sense May '22

[Tetry]

If this can't be achieved through an expression in the UI, then maybe you could suggest an alternative approach through the data load editor or the engine API if this makes any Sense.

Thanks

[Tetry · Accepted solution]

It turns out this can be achieved by applying a custom theme.