- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mekko chart - Drill-down dimension custom colors applied
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It turns out this can be achieved by applying a custom theme.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It turns out this can be achieved by applying a custom theme.