Solved: the color function of Qlik Sense - Qlik Community

lishuang · ‎2016-11-04

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!

amonjaras · ‎2016-11-05

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

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

Hope this helps!

View solution in original post

Anil_Babu_Samineni · ‎2016-11-05

What expression you tried? Would you describe more BRD

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

amonjaras · ‎2016-11-05

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

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

Hope this helps!

its_anandrjs · ‎2016-11-06

Dear,

Use simple colour function used in the Qlikview

Ex:-

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

Ex:-

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

Regards,

Anand