topic Absolute Value in QlikView

Absolute Value

sona_sa — Mon, 08 Sep 2014 03:49:03 GMT

Hi,

Please find the attached qvw file.

I have used Fabs function in my vMAPE calculation. After that all the negative sign is replacing with positive sign. But the calculation is same. But if we will see the total value of the expression it is wrong. Now it is coming 0.59. As per positive calculation it should be 0.75.

In Excel there is a function abs, which is providing the same output. i.e - 0.75.

Can any one give me the same output.

Thanks.

Re: Absolute Value

danieloberbilli — Mon, 08 Sep 2014 03:59:36 GMT

if you take away the fab() function, the result is still -0.59 ...so it seems that the mistake is not due to the fab() function.

Re: Absolute Value

danieloberbilli — Mon, 08 Sep 2014 04:02:45 GMT

This should work:

sum(aggr( Fabs((Sum(SALES_QTY) - Sum(SOP_Cts))/1000), Group, CATEGORY))

Re: Absolute Value

sona_sa — Mon, 08 Sep 2014 04:06:04 GMT

But After the calculation of = Sum(Actual)-Sum(Plan) whatever the figure is coming, Positive or Negative --> I want to convert in Positive and then Total of all the value. i.e is 0.75.

Re: Absolute Value

danieloberbilli — Mon, 08 Sep 2014 04:18:43 GMT

if you use sum(aggr( Fabs((Sum(SALES_QTY) - Sum(SOP_Cts))/1000), Group, CATEGORY))

it should result in