Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

antoniodneto
Contributor

Conditional Colors Extension

Hello Guys,

I'm trying to color my table following a conditional to highers is red, medium is yellow and lowes green.

The rows have different measures.

You guys know if have any extension to do that?

I'm not getting by expression, colormix, ifs, etc...

Tks a lot

18 Replies
jonvitale
Contributor III

Re: Conditional Colors Extension

Are you just trying to color the background of cells in a table? You can do that with the out-of-the-box table.

antoniodneto
Contributor

Re: Conditional Colors Extension

Hello Jonathan,

I'm trying something like that

exemplo_colour2.png

jonvitale
Contributor III

Re: Conditional Colors Extension

You should be able to do this using the background color for each column in the table.

Use the ColorMix function to create a gradient from 0 to 100 (or 1)

Maybe this post is relevant (it's about pivot tables, but the same concept should apply):

Gradients in pivot table

m_schindler
Contributor II

Re: Conditional Colors Extension

Hello Antonio,

would a heatmap fulfill your requirements?

If yes maybe try out http://branch.qlik.com/#!/project/56728f52d1e497241ae6983e (free) or the VizLib Heatmap (free up to 5 users iirc) .

Cheers,

Mathias

antoniodneto
Contributor

Re: Conditional Colors Extension

Hello Mathias! It's possible attach the files here? Because Github is blocked in my company.

Tks a lot!

m_schindler
Contributor II

Re: Conditional Colors Extension

Here you go.

Mathias

antoniodneto
Contributor

Re: Conditional Colors Extension

Hi Mathias, is not working.

Any another solution?

antoniodneto
Contributor

Re: Conditional Colors Extension

I got!! But I can't use.

I need to use 2 dimensions, but I have just one

Is one dimension (DATA) and some measures in the rows.

Tks!

m_schindler
Contributor II

Re: Conditional Colors Extension

Hi Antonio, have you tried Jonathan's suggestion?

Mathias

Community Browser