Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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

balkumarchandel
Specialist II
Specialist II

Hi Find attached App with percent calculation

sunny_talwar

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