Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number format into Milion

Hi,

I am new to qlikview.

I needs to convert into million formate and show on the Y asis as $250M

Example :

250,000,000

I want to show this  as

$250M

How can we show this in above formate ?

Thanks!.

Deepak

6 Replies
help4qv123
Creator II
Creator II

Hi,

go to chart properties-->number-->select money ...u wil get it....

send me ur mail id

CELAMBARASAN

Go to chart properties-->Number tab
Capture.PNG

Select the Expression and Give Symbol here based on your requirement.

Not applicable

fvelascog72
Partner
Partner

Hi,

Try in Expression:

num(sum(Value)/1000000,'$#.##0M')

prajapatiamar38
Creator II
Creator II

Hi..

GO to Chart Properties>Number tab

There you can set the symbol to Millions just write "M".

Thanks

help4qv123
Creator II
Creator II

This is the exp

num(sum(Value)/1000000,'$#.M')