topic Calculating Sum in QlikView

Calculating Sum

Sun, 30 Oct 2011 02:57:14 GMT

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?

Thanks

Calculating Sum

Sun, 30 Oct 2011 03:40:56 GMT

Use symbol in number format.

Kiran.

Calculating Sum

Sun, 30 Oct 2011 06:14:29 GMT

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

Calculating Sum

Sun, 30 Oct 2011 12:13:03 GMT

Keep thousand symbol as K. That should help you.

Kiran

Calculating Sum

Sun, 30 Oct 2011 13:56:43 GMT

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'

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.

Appreciate.

Thanks

Calculating Sum

kamalqlik — Tue, 08 Nov 2011 06:00:44 GMT

Hi...

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

Calculating Sum

Tue, 08 Nov 2011 06:28:08 GMT

Remove symbol and it will work out automatically.

Kiran.