Count colors in an expression

[Anonymous]

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!

[dwforest]

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.