Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Text Object, Text equation trouble

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!

5 Replies

Re: Text Object, Text equation trouble

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

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

MVP
MVP

Re: Text Object, Text equation trouble

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

or

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


both works

Not applicable

Re: Text Object, Text equation trouble

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!!

sasiparupudi1
Honored Contributor III

Re: Text Object, Text equation trouble

please close this thread by marking the correct answer

Community Browser