Complex Count?

Anonymous — Wed, 27 Aug 2014 15:11:03 GMT

Hello Guys !

I need some help. I've attached a QVW file.

Here is what i need:

I need a table which have Mês ('Month' in English) as Dimension and 1 expression.

This expression need to give me the amount of rows which the expression of 'RAB Calculated' is greather than of 'Meta RAB Calculated'.

This is simple to do, but, there is a problem:

Every 'Roteiro' have more than 1 'Data'. Example :

DATA ROTEIRO

01/01 1

02/01 1

03/01 1

01/01 2

02/01 2

03/01 2

So, if i do something like this :

count (if( RAB CALCULATED >= RAB CALCULATED, Roteiro))

It will count 30 rows, when i want only 1. So it sounds something like:

Count roteiro group by data.

In this case, i want a "Month Report" using DATA field.

In the QVW, the 'Ocorrencias' table, have one expression called "Acima do Rab" i have the final result (339).

So i need the Month (Mes) as Dimension and a expression counting it. Somebody can help me?

I see something like count (Roteiro<Data>) which means group by Data.

Thanks !

topic Complex Count? in QlikView