How to show values in line chart?

[#1]

Hi Team,

How to show values in Million(m) foramt and thousand(k) foramts in line chart

if(sum(Amount)>=1000000

,num(sum(Amount)/1000000,'#,##0.0 M')

,num(sum(Amount)/1000,'#,##0 K'))

I applied above formula ,but the trend line shows bleow

Millions shows down trend and Thousand shows up trend

Thanks

[#2]

Hi Team,

How to show values in Million(m) foramt and thousand(k) foramts in line chart

if(sum(Amount)>=1000000

,num(sum(Amount)/1000000,'#,##0.0 M')

,num(sum(Amount)/1000,'#,##0 K'))

I applied above formula ,but the trend line shows bleow

Millions shows down trend and Thousand shows up trend

Thanks

[#3]

That is because of Y axis. You need to fix the Y axis points.

[#4]

Go to the Number tab and set the below properties for each of the expression.  Hope this helps

Number Format Setting = Integer.

In the Thousand Symbol input field enter x Thousand.

In the Million Symbol box enter x Million.

In the Billion Symbol box enter, you guessed it, x Billion.

[#5]

Hi Streak

,

Its not working

[#6]

Can you post sample qvw ?

[#7]

Hi ,

Please find the qvd file

[kaushiknsolanki · Accepted solution]

Hi,

     Have a look at the attached example.

Regards,

Kaushik Solanki

[#9]

Thanks, Kaushik

Problem Solved

[nizamsha]

write  2 expression

first one

sum(access)

second one

if(sum(Access)>=1000000,

num(sum(Access)/1000000,'#,##0.0 M'),

num(sum(Access)/1000,'#,##0 K'))

for first one enable line and symbol check box

for the second one enable values on data poin it will give the output what u want