Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-08-06 05:54 AM

Number formatting

I want to ask a feature where i can change the display of large numbers between T to omit "000" at the end and M to avoid "000 000" at the end of the displayed number

For example wenn the number is 10,000 it will display 10T, and if the number is 10,000,000, it will be showed as 10M.

I have selected “cusom” under Number formatting with format pattern #.##0M. For 1.000.000.000 it doesn’t turn to 1.000M but 1.000.000.000M

Could anyone tell me how to solve it.

Capture.PNG

With many thanks.Capture2.PNG

318 Views
0 Likes
0 Replies