Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where to edit the number symbol in access point

Hi,

I was wondering if anyone knew how to find/edit the number symbol (thousand, million, billion symbol) property on access point.

Number Symbol on Desktop Version.png

9 Replies
Colin-Albert

These symbols only apply to the axis on charts.

To view a value as 1000s you will need to divide your data in the expression

E.g.  =Sum(value)/1000

Not applicable
Author

Thanks. I understand that it only applies to the axis on the charts. That is exactly what i want. Its because i dont display the values on each data point instead i have user hover over a datapoint to see the actual value. So i dont want to Divide the value by 1000. I want it to stay as it is but i want my axis points to become smaller/dynamic as the number increase/decrease

Not applicable
Author

You dont have to divide by 1000. Please check out the attached doc

Not applicable
Author

Thanks Ajay. I know how to do this on desktop. I am asking how to do this on access point. From web view.

We empower users to create their own charts so the default number format settings sometimes is not nice to look at so they ask how to change the number symbol as well on access point (not desktop)

Not applicable
Author

I couldn't find it on Access point. It should be here but its not.

Test.png

Not applicable
Author

i know... i have tried clicking everything but couldnt find it. maybe someone knows if there is trick to it

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

I don't think there is such option through access point.

Sokkorn
Master
Master

Hi Janet,

Here is a trick:

1. Create 4 variables. Go to Settings -> Variable Overview -> Click Add

     vSymbol

     vKSymbol

     vMSymbol

     vBSymbol

1.png

2. Create input box to control symbol

2.png

3. Go to chart properties -> Number tab

3.png

So that we manage symbol base on input box above.

Regards,

Sokkorn

Not applicable
Author

What Janet mentioned earlier was that users might create their own charts. There is no way to create symbols on those charts.

What you mentioned will work only for the existing ones but none the less its a good tip.