Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

FABS with variable?

When I copied this expression into a text box, I see Error: Error in expression: ')' expected.

=IF(($(vForecastRound)=0 and $(vActualRound)=0), IsNull(Null()), IF(FABS($(vNewVariance))>1,0, 1-FABS($(vNewVariance))))

I think the issue is related to FABS($(vNewVariance)) because this alone gives me the same error. Does FABS() not work in this case for some reason?

Thanks,

Cassandra

25 Replies
cbaqir
Specialist II
Specialist II
Author

OMG, I feel like an idiot... Thanks, Rob!

sinanozdemir
Specialist III
Specialist III

Thanks Rob.

I was driving myself crazy without realizing this.

cbaqir
Specialist II
Specialist II
Author

Tell me about it!

sinanozdemir
Specialist III
Specialist III

I blame it on Friday

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

It's a bit of an odd one that trips me sometimes. I added an additional comment about removing the Expression label to debug. That's usually the first place to start anytime $() is involved.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

cbaqir
Specialist II
Specialist II
Author

Thanks for your help!