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: 
madhuparnadhar
Contributor III
Contributor III

Format string as percentage

Hello all,

I am trying to format a string into percentage, but really struggling with Num and Num# functions. Below is the data which I receive from the data source :

Product NameRate
P15.766233766233767
P20.0
P34.247104247104247
P40.0
P54.086538461538462
P64.975124378109453
P70.0
P83.3932135728542914
P90.0
P104.10958904109589

 

I would like the field "Rate" (which is a string) to be formatted as percentage with only two places after decimal (so 5.76% for P1 say). I have to keep the number formatting as Auto, so I need to achieve this by Num/Num# functions.

Can anyone please help me ?

Thanks and Regards,

Madhuparna Dhar

 

Labels (4)
1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

Hi,

use this

load
"Product Name",
num(num#(Rate,'#.0############','.',',')/100,'#.## %','.',',') as Rate;
LOAD * INLINE [
Product Name, Rate
P1, 5.766233766233767
P2, 0.0
P3, 4.247104247104247
P4, 0.0
P5, 4.086538461538462
P6, 4.975124378109453
P7, 0.0
P8, 3.3932135728542914
P9, 0.0
P10, 4.10958904109589
];

Regards

View solution in original post

3 Replies
Anil_Babu_Samineni

Perhaps this?

Floor(Rate, '0.01')

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
martinpohl
Partner - Master
Partner - Master

Hi,

use this

load
"Product Name",
num(num#(Rate,'#.0############','.',',')/100,'#.## %','.',',') as Rate;
LOAD * INLINE [
Product Name, Rate
P1, 5.766233766233767
P2, 0.0
P3, 4.247104247104247
P4, 0.0
P5, 4.086538461538462
P6, 4.975124378109453
P7, 0.0
P8, 3.3932135728542914
P9, 0.0
P10, 4.10958904109589
];

Regards

madhuparnadhar
Contributor III
Contributor III
Author

Hi @martinpohl ,

This works perfectly.

Thank you so much for your quick help!

Regards,

Madhuparna