Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vinod2086
Contributor 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
Contributor III

Re: Table chart with Colour indicator

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

7 Replies
DavidŠtorek
Contributor III

Re: Table chart with Colour indicator

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
Contributor III

Re: Table chart with Colour indicator

Capture.PNG

agigliotti
Honored Contributor II

Re: Table chart with Colour indicator

I tried but i can't see the image.

DavidŠtorek
Contributor III

Re: Table chart with Colour indicator

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

That's what i see

Capture.PNG

Try with another character...

vinod2086
Contributor II

Re: Table chart with Colour indicator

Thanks for your reply David,

I'll check and let you know.

balabhaskarqlik
Honored Contributor

Re: Table chart with Colour indicator

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
Valued Contributor II

Re: Table chart with Colour indicator

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

Community Browser