Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Calculating Sum

I am trying to sum some data values as per the below chart.

Usage.png

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?

Thanks

6 Replies
Not applicable

Calculating Sum

Use symbol in number format.

Kiran.

Not applicable

Calculating Sum

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..?

Not applicable

Calculating Sum

Keep thousand symbol as K. That should help you.

Kiran

Not applicable

Calculating Sum

Hi Kiran,

Thanks Kiran. I have dones as follows. correct me if I am incorrect.

In Expression I have added

   Sum(F_Pg_Copy)/1000

Added Format Pattern, Symbol=',' Thousand Symbol ='K', Million Symbol  ='M' and Billion Symbol ='B'

Format_pattern.JPG

The outcome is

Y Axis contains ',' which I marked with an arrow.

After_adding_Pattern.JPG

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.

Appreciate.

Thanks

kamalqlik
Valued Contributor

Calculating Sum

Hi...

  Go in the Number tab of chart property and put thousand symbol as k

Not applicable

Calculating Sum

Remove symbol and it will work out automatically.

Kiran.