Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to display millions and thousands in bar chart?

Hi,

how to display values millions and thousands in bar chart in datapoints on the top of the bars

like this formate ,see below Attached file.

please  help me,

Thanks,

4 Replies
er_mohit
Master II
Master II

Sokkorn
Master
Master

Hi,

Your expression should be

If(Sum(FieldValue)>=1000000,Num(Sum(FieldValue)/1000000,'#,##0 M'),Num(Sum(FieldValue)/1000,'#,##0 K'))

Regards,

Sokkorn

Not applicable
Author

Thank you  very much Sokkorn ,

It's working fine ///////////////////////

Once again Thank you.

Sokkorn
Master
Master

Hi,

Please close this discussion by mark as correct answer.

Rgds,

Sokkorn