Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Count based on the cell's colour

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:

Exemple QV.jpg

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

1 Reply
Not applicable

Re: Count based on the cell's colour

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?

Community Browser