Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Tetry
Contributor II
Contributor II

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

Labels (3)
1 Solution

Accepted Solutions
Tetry
Contributor II
Contributor II
Author

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

View solution in original post

2 Replies
Tetry
Contributor II
Contributor II
Author

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
Contributor II
Contributor II
Author

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