Table chart with Colour indicator

[vinod2086]

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.

[DavidŠtorek · Accepted solution]

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]

[agigliotti]

I tried but i can't see the image.

[DavidŠtorek]

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

That's what i see

Try with another character...

[vinod2086]

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]

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