Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod2086
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
DavidŠtorek
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
DavidŠtorek
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

DavidŠtorek
Creator III
Creator III

Capture.PNG

agigliotti
Partner - Master III
Partner - Master III

I tried but i can't see the image.

DavidŠtorek
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...

vinod2086
Creator II
Creator II
Author

Thanks for your reply David,

I'll check and let you know.

balabhaskarqlik

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

pablolabbe
Luminary Alumni
Luminary Alumni

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