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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression error

Hi All,

I am performing simple calculation, not sure why it is giving expression error. Please refer to the attached QVW and suggest.

14 Replies
anbu1984
Master III
Master III

=Num(F2/(F2+F3+F4) *100,'####.##') & '%'

tresesco
MVP
MVP

See attached qvw; first calculated dimension.

Not applicable
Author

Please try with the below code:[


=Num(F2/(F2+F3+F4) *100,'#0.##%')


Regards,

Joshmi

Not applicable
Author

This works.

=Num(F2/(F2+F3+F4) '#.00 %')

THnaks

Not applicable
Author

=num(F2/(F2+F3+F4),'#00.00%')