Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
guyvermeiren
Contributor

Format number on data points as thousands

Hello,

I'm working on a bar chart where my axes are already formatted in thousands (K).

Now I would like to show the values on the the data points also as K-formatted values.

Format.JPG

Anyone any idea ?

Thanks in advance

Kind regards,

Guy

9 Replies

Re: Format number on data points as thousands

Divide each expression by 1000

Hope it helps

guyvermeiren
Contributor

Re: Format number on data points as thousands

Alessandro,

I want to keep my expressions for use in an other table.

I just want to change the format of the number to keep the logic with the axe-format.

Kind regards,

Guy


Re: Format number on data points as thousands

In Tab Number set K as Symbol and K as thousands symbol

sudeepkm
Valued Contributor III

Re: Format number on data points as thousands

Have you tried like below?

T117856.png

guyvermeiren
Contributor

Re: Format number on data points as thousands

Doesn't work.

The thing is that for example the number 427237 has to be shown (formatted) as 427K

Kind regards,

Guy

Re: Format number on data points as thousands

Try what I posted before and let me know please

guyvermeiren
Contributor

Re: Format number on data points as thousands

K as thousands symbol OK.

But what do you mean by K as Symbol. Where do Iput that in Tab Number ??

sudeepkm
Valued Contributor III

Re: Format number on data points as thousands

I thought you already have divided your expr with a 1000 and have the Number Format

Symbol: $

Thousands: K

Million: M

Billion: B

Re: Re: Format number on data points as thousands

Here it is

Community Browser