topic Text Object, Text equation trouble in QlikView

Text Object, Text equation trouble

Fri, 21 Aug 2015 14:32:00 GMT

I am having trouble getting this equation to resolve

=text(‘Expected Cost for Fees Awarded: ‘) & num($(fees_awarded_expected),’$#,##0’)

error msg indicates, ')" expected but I am not seeing a missing ).

Any guidance to this new Qlik user would be greatly appreciated!

Re: Text Object, Text equation trouble

marcus_sommer — Fri, 21 Aug 2015 15:27:41 GMT

The text() won't be needed:

= ‘Expected Cost for Fees Awarded: ‘ & num($(fees_awarded_expected),’$#,##0’)

and if your variable returned a valid number then it should work.

- Marcus

Re: Text Object, Text equation trouble

Peter_Cammaert — Fri, 21 Aug 2015 15:35:31 GMT

I guess the error occurs because of something that Marcus already hinted at: whenever $(fees_awarded_exprected) doesn't resolve to a valid expression, the num() function syntax will become invalid.

Make sure that variable fees_awarded_expected does contain a valid value or field name.

Peter

Re: Text Object, Text equation trouble

maxgro — Fri, 21 Aug 2015 15:37:36 GMT

=text('Expected Cost for Fees Awarded: ') & num($(fees_awarded_expected),'$#,##0')

='Expected Cost for Fees Awarded: ' & num($(fees_awarded_expected),'$#,##0')

both works

Re: Text Object, Text equation trouble

Fri, 21 Aug 2015 15:43:12 GMT

Thanks everyone for the quick replies ! I went back and took a look at the variables I created and, found that I had capitalized the word Fees in the variable. Total newbie error, however, lesson learned in that I now know that matters. Thanks so much once again for the quick replies!!

Re: Text Object, Text equation trouble

sasiparupudi1 — Tue, 25 Aug 2015 17:18:31 GMT

please close this thread by marking the correct answer