topic Error in calculated dimension in QlikView

Error in calculated dimension

Mon, 18 Apr 2011 11:07:08 GMT

Hi,

I've tried to introduce a calculated dimension in a chart and it gives me an error in the expression, could somenoe chek it and tell me where the problem is??

=IF(SITUACIÓN <> 'P3','OBSOLETO',

IF((sum({<[Luogo di spedizione]={'6a01'}>}Venta)/[Qtà stk. val.])>=1,'BUENA ROTACIÓN EN P3','MALA ROTACIÓN EN P3'))

Thanks for your time!!!

Error in calculated dimension

nathanfurby — Mon, 18 Apr 2011 11:28:48 GMT

Do you need double quotes around the set analysis part? Just a guess from looking:

sum({<[Luogo di spedizione]={"6a01"}>}Venta)

Error in calculated dimension

erichshiino — Mon, 18 Apr 2011 11:30:49 GMT

Try

=IF(SITUACIÓN <> 'P3','OBSOLETO',

IF((sum({<[Luogo di spedizione]={'6a01'}>}Venta)/sum([Qtà stk. val.]))>=1,'BUENA ROTACIÓN EN P3','MALA ROTACIÓN EN P3'))

but I think you will need a Aggr expression to make it work as you need.

Where would you apply the SITUACIÓN FIELD?

Let us say that it if for Regions

then your expression could be:

=aggr( IF(SITUACIÓN <> 'P3','OBSOLETO',

IF((sum({<[Luogo di spedizione]={'6a01'}>}Venta)/sum([Qtà stk. val.]))>=1,'BUENA ROTACIÓN EN P3','MALA ROTACIÓN EN P3')), REGION)