topic Why sum(distinct fabs($(Var) -([Variable]))) = ERROR ? in QlikView

Why sum(distinct fabs($(Var) -([Variable]))) = ERROR ?

Mon, 20 Sep 2010 12:07:16 GMT

Hellow, I think you will help me.

I Have in pivot table : sum( distinct fabs ( $(Var) - ([Variable]) ) ) = error , { Var = avg( [Variable] ) } ;
sum( distinct fabs ( avg( [Variable] ) - ([Variable]) ) ) = error

But : sum(distinct fabs(4.44 -([Variable]))) = all right

WHY ??????

Why sum(distinct fabs($(Var) -([Variable]))) = ERROR ?

Miguel_Angel_Baeyens — Mon, 20 Sep 2010 12:16:35 GMT

Hello,

How did you create that variable? Try not using dollar expansion

sum(distinct fabs(var -([Variable])))

Hope that helps

Why sum(distinct fabs($(Var) -([Variable]))) = ERROR ?

Mon, 20 Sep 2010 12:30:16 GMT

Variable I create through the "Variable Overview".

Without '$' not work.

Why sum(distinct fabs($(Var) -([Variable]))) = ERROR ?

Miguel_Angel_Baeyens — Mon, 20 Sep 2010 12:36:46 GMT

Just for testing purposes, create a new text object and write

=$(Var)

and likewise without $(). In the first case, it should return the result of the formula (avg([Variable])) in a numeric format and in the second, the formula itself. Is that right?

Why sum(distinct fabs($(Var) -([Variable]))) = ERROR ?

Tue, 21 Sep 2010 16:14:25 GMT

Thank you for your help, I solved the problem, considering a "avg(Variable)" in the script.