Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

Number Format

Hi Qlik,

I've below two columns in my Dimension value which needs to be format to 00.0% format. 

Ex: 23.1%  (Need one decimal with %).

My original value is 

MuraliPrasath_0-1632407088618.png

Any help would be highly appreciated. thanks!

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like below

Num(UrDim/100, '##.#%')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
MayilVahanan

HI 

Try with Number format

Num(UrDim, '##.#%')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
MuraliPrasath
Creator III
Creator III
Author

Hi Mayil,

I get this output after using your logic. Need further help on this. thnaks

MuraliPrasath_0-1632409881657.png

 

MayilVahanan

Hi

Try like below

Num(UrDim/100, '##.#%')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.