Discussion board where members can get started with QlikView.
I am trying to sum some data values as per the below chart.
I want to display values in charts 139.43K instead of 139434 if it goes in millions it should be displayed in millions. How do I do it?
Use symbol in number format.
Thanks Kiran for your quick help. How do I do it?
Chart Properties-> select Number -> Under Number format Settings Select Number, then What should I do in Symbol, ThousandSymbol and Million Symbol etc..?
Keep thousand symbol as K. That should help you.
Thanks Kiran. I have dones as follows. correct me if I am incorrect.
In Expression I have added
Added Format Pattern, Symbol=',' Thousand Symbol ='K', Million Symbol ='M' and Billion Symbol ='B'
The outcome is
Y Axis contains ',' which I marked with an arrow.
Any way We can automatically define this? If > 1000 then the valuye will be display as K, (instead of 139434 it should display 139.43K and if the value is 139434000 it should display as 139.434M)
Also the Y axis should reflect the scale accordingly.
Sorry I am new and trying to learn.
Go in the Number tab of chart property and put thousand symbol as k
Remove symbol and it will work out automatically.