Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
antoniodneto
Creator II
Creator II

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

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
Creator II
Creator II
Author

Hello Jonathan,

 

I'm trying something like that

 

 

jonvitale
Creator III
Creator III

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_s
Partner - Creator II
Partner - Creator II

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
Creator II
Creator II
Author

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

Tks a lot!

m_s
Partner - Creator II
Partner - Creator II

Here you go.

Mathias

antoniodneto
Creator II
Creator II
Author

Hi Mathias, is not working.

Any another solution?

antoniodneto
Creator II
Creator II
Author

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_s
Partner - Creator II
Partner - Creator II

Hi Antonio, have you tried Jonathan's suggestion?

Mathias