Qlik Community

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS

The "Auto" Number format should allow currency symbols

Oleg_Troyansky

The "Auto" Number format should allow currency symbols

The "auto" number format is great - it automatically shows the number in thousands, millions, billions, etc... What would be extremely helpful is the ability to add a currency symbol to it. Without it, we are still forced to evaluate the number in a nested IF statement and format the number manually, just because we can't add the dollar sign to the number.

Example: in order to produce something like this:    $32.1M

We have to calculate something like this:

IF(Sum(Sales)>1000000000, num(Sum(Sales)/1000000000, '$#,##0.0B'),

IF(Sum(Sales)>1000000, num(Sum(Sales)/1000000, '$#,##0.0M'),

 IF(Sum(Sales)>1000, num(Sum(Sales)/1000, '$#,##0.0k'),

num(Sum(Sales), '$#,##0'))))

Pretty ridiculous, don't you think? All this could be saved with a simple checkbox "Currency" and the currency symbol next to it...

Thank you for your consideration!

Oleg Troyansky

5 Comments
Patric_Nordstrom
Employee
Employee

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,

Patric

Status changed to: Open - Collecting Feedback
andrew_2817
Contributor II
Contributor II

I second this motion. My customers are always complaining that I don't have a dollar sign on my Auto numbers.

luttik
Contributor
Contributor

I'd like to second this, and add that this kind of formula is not even an option in line / bar charts. In these charts you have to choose between a readable number and an explicit currency.

schmidtkm37
Contributor III
Contributor III

This seems like low hanging fruit that could deliver a quick, impactful win for customers.  I think you should consider adding this to your short-term roadmap.

francesco_menin
Partner
Partner

That's something very useful we'd love to have.