Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lishuang
New Contributor III

the color function of Qlik Sense

Has anyone used the color function of Qlik Sense which is the same as Excel?I want to change to red when the data values for the PivotTable data is low.

Thanks in advance!

1 Solution

Accepted Solutions
amonjaras
Contributor II

Re: the color function of Qlik Sense

In edit mode, go to the measure you want to color, and enter a background or color expression:

Screen Shot 2016-11-05 at 12.49.03 p.m..png

Expression example: if(sum(Ventas) / Sum(Presupuesto) <.5, LightRed(),lightgreen())

Hope this helps!

3 Replies

Re: the color function of Qlik Sense

What expression you tried? Would you describe more BRD

amonjaras
Contributor II

Re: the color function of Qlik Sense

In edit mode, go to the measure you want to color, and enter a background or color expression:

Screen Shot 2016-11-05 at 12.49.03 p.m..png

Expression example: if(sum(Ventas) / Sum(Presupuesto) <.5, LightRed(),lightgreen())

Hope this helps!

Re: the color function of Qlik Sense

Dear,

Use simple colour function used in the Qlikview

Ex:-

Red(), Green(), RGB(255,210,247)

Ex:-

If( Sales < 0, Red(), Green())

Regards,

Anand