can anyone help me out??

[suvechha_b]

Can anyone help me out??

What does this expression means??

I am new to qlikview?? and I need to understand this which will help me in my calculation...

if([Accuracy Type] = 'MAPE1' or [Accuracy Type] = 'MAPE3',(if(1 - ($(vAbsError)/sum([Actual Units])) < 0 or sum([Actual Units]) < 0,0,1 - ($(vAbsError)/sum([Actual Units])))),sum([Actual Units])/sum([Forecast Units]))

[#2]

here Nested if condition are used --

example of nested if condition--

if(A>2,B,IF(A>4,D,IF(A>6,F)))

MEANING OF ABOVE EXPRESSION IS--

IF VALUE OF A GREATER THAN 2 THEN OUTPUT IS B IF NOT GREATER THAN 2 THEN AGAIN CHECK CONDITION  IF VALUE OF A GREATER THAN 4 THEN  OUTPUT IS D IF NOT THEN AGAIN CHECK CONDITION IF VALUE OF A GREATER THAN 6 THEN OUTPUT IS F.

SIMILARLY  MEANING OF YOUR SYNTAX ---

IF  [Accuracy Type] = 'MAPE1  OR  [Accuracy Type] = 'MAPE3' 

THEN

           IF (1 - ($(vAbsError)/sum([Actual Units])) )< 0     or   sum([Actual Units]) < 0  

         THEN  0

           ELSE   1 - ($(vAbsError)/sum([Actual Units]

ELSE

sum([Actual Units])/sum([Forecast Units]

[suvechha_b]

thanks a lot...for the explanation...

Now please help me in the below expression,

what does it means??

sum(aggr(fabs(sum([Absolute Error])),[Product Code],[Fiscal Month],[Fiscal Year],Measure,[Division Product Manager Code]))

[suvechha_b]

thanks a lot...for the explanation...

Now please help me in the below expression,

what does it means??

sum(aggr(fabs(sum([Absolute Error])),[Product Code],[Fiscal Month],[Fiscal Year],Measure,[Division Product Manager Code]))

[suvechha_b]

Can you please explain me this expression??

1 - ($(vAbsError)/sum([Actual Units]

[suvechha_b]

Can you explain me this expression??

1 - ($(vAbsError)/sum([Actual Units]

[ariel_klien]

hi

This function making the sum of the aggregate of The absolute value(fabs) of sum of [Absolute Error] 

when the dimension we calculate are:

[Product Code],

[Fiscal Month],

[Fiscal Year],

Measure,

[Division Product Manager Code]

[ariel_klien]

Hi,

you need to check what is the variable vAbsErro => ctrl+alt+v (Variable Properties)

then you can understand the function