Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MeeraAgrawal
Creator
Creator

Number Formatting

Hi Guys 

Hoping you all guys are safe..

Can you please help me out this issue .Revenue Unit is showing as 'G' how number formatting  make it custom to show as '$NumberM' or in Million in cloud version, M for million please find the attached screen shot to make its more understandable for you.

Labels (4)
1 Solution

Accepted Solutions
Taoufiq_Zarra

if you want the display per million, there are several ways like :

1-Divide your value by 1000000

2-apply  custom format  :# ##0,00 M

for example :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

if you want the display per million, there are several ways like :

1-Divide your value by 1000000

2-apply  custom format  :# ##0,00 M

for example :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
MeeraAgrawal
Creator
Creator
Author

Thanks a lot . It's working fine.