Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count colors in an expression

Hi,

I'm using Qlik Sense Desktop and was wondering if it's possible to count the number of colors in a row of a table? For example. I have 6 rows and 12 columns. I'd like to count how many Red, Amber and green cells I Have for the most recent 6 columns.

I'm doing this because I'm creating a formula that gives me 1 "average" color based on the number of red, ambers and greens I have.

Thanks!

1 Reply
dwforest
Specialist II
Specialist II

If you have the criteria for determining each columns color, that should be able to be combined to determine the over all color.

I can't think of any scenario where you can query ui properties.