topic Count colors in an expression in App Development https://community.qlik.com/t5/App-Development/Count-colors-in-an-expression/m-p/96898#M6465 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 29 Jun 2018 20:40:42 GMT Anonymous 2018-06-29T20:40:42Z Count colors in an expression https://community.qlik.com/t5/App-Development/Count-colors-in-an-expression/m-p/96898#M6465 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 29 Jun 2018 20:40:42 GMT https://community.qlik.com/t5/App-Development/Count-colors-in-an-expression/m-p/96898#M6465 Anonymous 2018-06-29T20:40:42Z Re: Count colors in an expression https://community.qlik.com/t5/App-Development/Count-colors-in-an-expression/m-p/96899#M6466 <HTML><HEAD></HEAD><BODY><P>If you have the criteria for determining each columns color, that should be able to be combined to determine the over all color. </P><P>I can't think of any scenario where you can query ui properties.</P></BODY></HTML> Fri, 29 Jun 2018 20:48:11 GMT https://community.qlik.com/t5/App-Development/Count-colors-in-an-expression/m-p/96899#M6466 dwforest 2018-06-29T20:48:11Z