Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

amithmurali
Contributor

Show in Millions instead of showing in Thousands.

Hi,

I want to show the values in my chart in Millions even when the values goes to the Thousands, like for "500,000". i want to show it as "0.5 M". can any one help me to achieve this.

1 Solution

Accepted Solutions
MVP
MVP

Re: Show in Millions instead of showing in Thousands.

Try like:  Num(YourExpression/1000000, '#,##0.##M')

Or similar format in the number tab with million division in th expression.

2 Replies
MVP
MVP

Re: Show in Millions instead of showing in Thousands.

Try like:  Num(YourExpression/1000000, '#,##0.##M')

Or similar format in the number tab with million division in th expression.

amithmurali
Contributor

Re: Show in Millions instead of showing in Thousands.

Thankyou tresesco for the idea. i have created a new field in the script by dividing it by 100,000 .

Community Browser