Count of "Alerts' from IF a condition?

[poluvidyasagar]

Hi ,

I am trying to achieve the following:

Here is my pivot table from Qlikview:

Part	Week	ERPQty	ActualQty	Check
A	10	100	50	Alert
A	11	200	210	OK
A	12	-	280	OK
B	10	-	100	OK
B	11	-	220	OK
B	12	400	410	OK
C	10	500	550	OK
C	11	-	120	OK
C	12	200	100	Alert

I am trying to plot in a bar chart number of "Alert" values by week.

ERP Qty is measure calculated as follows:

=Aggr(Sum({<Location={'L'},Type={'RC'}>}ERPQty),Part,Week)

Actual Qty is a measure calculated as follows:

=Aggr(sum(ActualQty),Part,Week)

Check is a measure calculated as follows:

=if(ERPQty>ActualQty,'Alert','OK')

Now i would like to plot these count of alerts on bar chart...

Dimensions: Week

Measure:

=Count(Aggr(If(Aggr(Sum({<Location={'L'},Type={'RC'}>}ERPQty),Part,Week) >Aggr(sum(ActualQty),Part,Week),'Alert'),'Alert'))

I am sure this measure expression wrong.. Can someone help me to correct this expression?

I have also attached the qvw file.

Thanks,
Vidya

[neelamsaroha157 · Accepted solution]

Check this out.