Qlik Sense colouring with many values for a dimension

netquest_oem — Thu, 12 Apr 2018 09:08:41 GMT

Hi,

Our problem is that we have a dimension with more than 5,000 values and user only sees 5-10 values at a time. If we don't define persistent colours, we may encounter 2 problems:

Colours are not homogeneous between different charts (with same dimension) and between data reloads
Colours overlap sometimes because there are not 5,000 visually different colours.

We have tried to define persistent colours for that dimension but we are facing with a 100 limit:

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Colors/assigning-colors-to-dimension-values.htm

Another way of solving it is defining colour by expression. We model a table with dimensionValue - Colour and then set the colour by expression. The problem is that then legend disappears:

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Colors/color-by-expression.htm‌

Does anyone have any possible solution?

Thanks.

topic Qlik Sense colouring with many values for a dimension in App Development

Qlik Sense colouring with many values for a dimension