topic Re: error in expression in QlikView

error in expression

Anonymous — Mon, 16 Feb 2015 14:19:01 GMT

Hello,

I am writing this expression in Resident table, but it is throwing me an error:

SUM([FARE]+ [TAX])+ SUM(IF([DOCTYPE]='2',(-1*fabs(IsNull([MEAL AMOUNT]),0)), fabs(IsNull([MEAL AMOUNT]),0)))

AS [TOTAL FARE],

Please suggest.

Regards,

Balraj

Michiel_QV_Fan — Mon, 16 Feb 2015 14:22:35 GMT

SUM([FARE])

+ sum([TAX])

+ SUM(

IF([DOCTYPE]='2',

(-1*fabs(IsNull([MEAL AMOUNT]) =-1,0)),

fabs(IsNull([MEAL AMOUNT]) =-1,0)))

maxgro — Mon, 16 Feb 2015 14:28:59 GMT

fabs has 1 parameter

Anonymous — Mon, 16 Feb 2015 14:35:11 GMT

what do you want to achive/to sum?

isnull(MEAL_ACCOUNT) is a condition and Returns -1 or 0

sum(-1*fabs(MEAL_ACCOUNT) if MEAL_Count is null? _1*0 = 0 can be achieved easier

Anonymous — Mon, 16 Feb 2015 18:05:54 GMT

RUDOLF,

MY MENTIONED EXPRESSION THROWING A SYNATX ERROR, THESE ARE THE SOME PARAMETER TO ACHIVE SOME RESULT IN BUSINESS.

CORRECT ME IF I AM MAKING ANY MISTAKE IN EXPRESSION.

Anonymous — Mon, 16 Feb 2015 20:36:03 GMT

As Massimo said, function fabs() has one parameter. You're trying to use two, this is your syntax mistake.

As for the business - I don't understand your third sum. What are you trying to calculate here?

jduenyas — Mon, 16 Feb 2015 21:17:22 GMT

isnull in TSQL like ISNULL(a,b) returns b if a is null

But it is not in QlikView which is like the IsNull in Basic, Isnull returns True or False (-1 or 0)

Besides, Fabs requires only one parameter and returns the Absolute value Fabs(-20) = 20

jduenyas — Mon, 16 Feb 2015 21:20:22 GMT

Your IsNull([MEAL AMOUNT]),0) should read like so:

If(IsNull([MEAL AMOUNT), 0, [MEALAMOUNT])