Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Have a look at the attached example.
Regards,
Kaushik Solanki
That is because of Y axis. You need to fix the Y axis points.
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.
Hi Streak
,
Its not working
Can you post sample qvw ?
Hi ,
Please find the qvd file
Hi,
Have a look at the attached example.
Regards,
Kaushik Solanki
Thanks, Kaushik
Problem Solved
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