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
