Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator

Script Calculation as Percentage

Hello,

Im trying to divide one figure by another in the load script which works fine, however I want the result to be a percentage not a number. 

How can I do this in the script??

Thank You

1 Solution

Accepted Solutions
sunny_talwar

Force it to be a % by doing =Num(x/y, '#,##0.00%')

Best,

S

View solution in original post

3 Replies
sunny_talwar

Force it to be a % by doing =Num(x/y, '#,##0.00%')

Best,

S

Anonymous
Not applicable

Hi Find attached App with percent calculation

sunny_talwar

My bad, Use this instead: =Num(x/y/100, '#,##0.00%')