Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lishuang
Contributor III
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
Partner - Creator II
Partner - Creator II

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!

View solution in original post

3 Replies
Anil_Babu_Samineni

What expression you tried? Would you describe more BRD

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
amonjaras
Partner - Creator II
Partner - Creator II

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!

its_anandrjs

Dear,

Use simple colour function used in the Qlikview

Ex:-

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

Ex:-

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

Regards,

Anand