Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.