Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Table chart with Colour indicator

Hi All,

I have a requirement to display colour indicator between range of values.

ex: monthly fuel consumption- previous month fuel consumption=0-100 Green colour

monthly fuel consumption- previous month fuel consumption<0 RED colour else amber.

please find the attached SS.

i am not understanding how to implement in qlik sense.

Please help me.

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Hi,

you can use some of unicode characters‌ (like Chr(9209)) and than use conditional colouring in text colour expression like

If( your expression<0,Red(),If(your expression>=0 and your expression<=100,green(),RGB(255, 191, 0)))

Result should match your requirement.

Hope it helps

View solution in original post

7 Replies
Highlighted
Creator III
Creator III

Hi,

you can use some of unicode characters‌ (like Chr(9209)) and than use conditional colouring in text colour expression like

If( your expression<0,Red(),If(your expression>=0 and your expression<=100,green(),RGB(255, 191, 0)))

Result should match your requirement.

Hope it helps

View solution in original post

Highlighted
Creator III
Creator III

Capture.PNG

Highlighted
Partner
Partner

I tried but i can't see the image.

Highlighted
Creator III
Creator III

Unfortunately it has something to do with your local settings probably.

That's what i see

Capture.PNG

Try with another character...

Highlighted
Creator II
Creator II

Thanks for your reply David,

I'll check and let you know.

Highlighted

Check these, to create indicators in chart objects of Qlikview or QlikSense.

https://community.qlik.com/docs/DOC-8356

https://community.qlik.com/docs/DOC-8421

Highlighted
Luminary
Luminary

Don´t Forget !

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others