Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show values in line chart?

Hi Team,

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

please find the attached doc

Thanks

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Something like this:

if(sum(Amount)>=1000000

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

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

Replace sum(Amount) with the expression you use now.


talk is cheap, supply exceeds demand

View solution in original post

7 Replies
Gabriel
Partner
Partner

Hi,

First thing I will do is, go to chart properties ->Number tab -> bottom right Thousand Symbol enter TH (or whatever you prefer) -> Million Symbol enter M (or whatever symbol you prefer). Then go to Expression tab then check Values on Data Points. Click OK.

Hope that helps

Regards,

Gabriel

jagan
MVP
MVP

PFA file, hope it helps you.

Regards,

Jagan.

Not applicable
Author

Hi jagan,

Iam unable to open qvd file

could you post those steps

thanks

Gysbert_Wassenaar

Something like this:

if(sum(Amount)>=1000000

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

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

Replace sum(Amount) with the expression you use now.


talk is cheap, supply exceeds demand

View solution in original post

jagan
MVP
MVP

Hi,

Please find attached file.

Regards,

Jagan.

Not applicable
Author

Excellent Wassennar,

Thanks

Not applicable
Author

LINECHART1.JPG

Hi Wassennar,

I applied your formula ,but the trend line shows above

Millions shows down trend and Thousand shows up trend

Thanks