Count based on the cell's colour

Tue, 03 Dec 2013 14:20:35 GMT

Hey everyone,

I would like to find an expression that is able to count the number of cells in my table that are Red or Green.

For example:

For example, i have 4 differents types of meeting. Each of these meetings needs to be done once a week. When the meeting is proprely done, the cell is Green, if the meeting wasn't done or not yet done, the cell is red.

I would like to know if it's possible to count the number of green cells that occurs before a particular date (ex.: date meeting).

For example, if i select the 1st-december, i will see the number 3, because 3 meetings were done before this date.

Thx a lot for your help !

Best regards,

Arnaud

Re: Count based on the cell's colour

Tue, 03 Dec 2013 15:01:41 GMT

It is possible, but you will not be counting the number of Green or Red, you will be counting the number of meetings properly done before a particular date. Same number, but very different ways of going about it. What formula do you use to calculate the background colors?

topic Re: Count based on the cell's colour in QlikView

Count based on the cell's colour

Re: Count based on the cell's colour