Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sarah_lamb
New Contributor III

Table Background Colour Scale Expressions

Hi all,

I'm trying to make a chart similar to the one below within Qlik Sense using background colour expressions but can't see how to get a colour scale.

SurfaceMapping.PNG

Can anyone provide guidance on how this can be achieved using background colour expressions or any other method please?

Any and all responses much appreciated, thank you.

4 Replies

Re: Table Background Colour Scale Expressions

It's probably easiest to use the ColorMix wizard in Qlikview to generate the color expression and then copy that expression over to the Qlik Sense app.


talk is cheap, supply exceeds demand
reddys310
Honored Contributor II

Re: Table Background Colour Scale Expressions

Hi Sarah,

As Gysbert suggested, make use of the ColorMix wizard in Qlikview to generate an expression and copy it across to Qliksense.

sarah_lamb
New Contributor III

Re: Table Background Colour Scale Expressions

That's great, thank you Gysbert and Sangram

sarah_lamb
New Contributor III

Re: Table Background Colour Scale Expressions

Hi all,

I've created an expression using the ColorMix wizard and copied this over to my pivot table in Sense but this only compares values by column, not across the whole table.  I've have a date dimension within the rows section and a time dimension within the column section and the background colour expression is applied to the measure.

Does anyone know of a way that the background colour expression can be applied across the whole table, not by column?

Any and all responses much appreciated, thank you.