topic Re: counting based on color coding in QlikView https://community.qlik.com/t5/QlikView/counting-based-on-color-coding/m-p/886292#M1014389 <HTML><HEAD></HEAD><BODY><P>Please post a sample qvw</P><P></P><P>Andy</P></BODY></HTML> Thu, 09 Apr 2015 13:09:08 GMT awhitfield 2015-04-09T13:09:08Z counting based on color coding https://community.qlik.com/t5/QlikView/counting-based-on-color-coding/m-p/886290#M1014387 <HTML><HEAD></HEAD><BODY><P>In a straight table i have a feild values coloured red,green, yellow. can i count the total number of reds,green, yellow?</P></BODY></HTML> Thu, 09 Apr 2015 12:59:36 GMT https://community.qlik.com/t5/QlikView/counting-based-on-color-coding/m-p/886290#M1014387 2015-04-09T12:59:36Z Re: counting based on color coding https://community.qlik.com/t5/QlikView/counting-based-on-color-coding/m-p/886291#M1014388 <HTML><HEAD></HEAD><BODY><P>What formula's determine the colors?&nbsp; Could you attach an example?</P></BODY></HTML> Thu, 09 Apr 2015 13:01:49 GMT https://community.qlik.com/t5/QlikView/counting-based-on-color-coding/m-p/886291#M1014388 joshabbott 2015-04-09T13:01:49Z Re: counting based on color coding https://community.qlik.com/t5/QlikView/counting-based-on-color-coding/m-p/886292#M1014389 <HTML><HEAD></HEAD><BODY><P>Please post a sample qvw</P><P></P><P>Andy</P></BODY></HTML> Thu, 09 Apr 2015 13:09:08 GMT https://community.qlik.com/t5/QlikView/counting-based-on-color-coding/m-p/886292#M1014389 awhitfield 2015-04-09T13:09:08Z Re: counting based on color coding https://community.qlik.com/t5/QlikView/counting-based-on-color-coding/m-p/886293#M1014390 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>no you can't count color based fields, but you can set up a flag according to color and sum(aggr(sum(flag), FieldValue))</P><P></P><P>best regards</P><P>chris</P></BODY></HTML> Thu, 09 Apr 2015 13:37:42 GMT https://community.qlik.com/t5/QlikView/counting-based-on-color-coding/m-p/886293#M1014390 2015-04-09T13:37:42Z