When I create a dashboard to mantain a good layout and to offer a good user experience always I need to set the same color for the same dimension value in each chart.
Unfortunally there isnt' a easy way to do this, and often a solution is to create some additional fields (R,G,B) for each dimension.
I don't like to have dozens of fields in my model with the problem to naming them.
To turn around this problem, I writed a single expression in a variable that doing all for me and now I use it always.
Let's see if you like this method too.
The idea is to use the functions Pick(Match(...)) to realize the magic.
I use QlikView Test Script and Qlikview Components library to realize an example. Test Script create the dimensions Dim1, Dim2, Dim3 and the expressions.
For Dim1 the values are A, B, C
For Dim2 the values are a, b, c, d, e, f
For Dim3 the values are X, Y, Z
For each values in dimensions need to set a variable with the associate color, to do easy this I use ColorTheme.xlsm file and use Qvc.ColorTheme to read it.
Now the best point... our function Pick(Match(...)), that I called App.Color.GetForField and set the value in Settings.xlsx.
Here the value:
=Pick(Match(Only($(=$1)), ' & Chr(39) & Concat({1} DISTINCT $(=$1), Chr(39) & Chr(44) & Chr(39)) & Chr(39) & '), ' & PurgeChar( Replace( 'App.Color.v.Dimension.$(=$1).' & Concat({1} DISTINCT $(=$1), chr(10) & ',App.Color.v.Dimension.$(=$1).') , ' ', '_'), '[]') & ')'
To use it in a chart write $(=$(App.Color.GetForField('[Dim1]'))) in the expression's backgroud property
The values in specificated dimension get automatically choosed color.
I hope you like this.
Regards
Luca Jonathan Panetta
