Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Number Formatting

Hi,

I have this value 2,616 981,182.16 when i select Number in Number formatting option in Qliksense but after changing it to Auto it gives me 2.62G.

What does G signify?

How can I convert it in Million?

4 Replies
Anonymous
Not applicable
Author

G signifies one thousand million.

Anonymous
Not applicable
Author

Thank you Bill and could you please tell me what is the full form of G?

Anonymous
Not applicable
Author

karthiksrqv
Partner - Creator II
Partner - Creator II

Hi Shivali,

One way to achieve it would be by dividing the expression by 1,000,000 and then using '#,##0M' as the custom format in formatting pane.