Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.