topic Re: can anyone help me out?? in QlikView

can anyone help me out??

suvechha_b — Thu, 25 Jul 2013 10:13:10 GMT

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]))

Re: can anyone help me out??

Thu, 25 Jul 2013 10:30:13 GMT

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]

Re: can anyone help me out??

suvechha_b — Thu, 25 Jul 2013 11:05:09 GMT

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]))

Re: can anyone help me out??

suvechha_b — Thu, 25 Jul 2013 11:05:15 GMT

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]))

Re: can anyone help me out??

suvechha_b — Thu, 25 Jul 2013 11:33:57 GMT

Can you please explain me this expression??

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

Re: can anyone help me out??

suvechha_b — Thu, 25 Jul 2013 11:34:24 GMT

Can you explain me this expression??

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

Re: can anyone help me out??

ariel_klien — Thu, 25 Jul 2013 12:12:28 GMT

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]

Re: can anyone help me out??

ariel_klien — Thu, 25 Jul 2013 12:14:49 GMT

Hi,

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

then you can understand the function