topic Re: Sum for different months in QlikView

Sum for different months

a_brancati — Wed, 25 Nov 2020 16:16:04 GMT

Hello everybody! I have this kind of table

Months Sales

January 50

January 60

Fabruary 60

March 100

March 10

March 30

I would like to a have a stacked column chart that shows the sum of sales per month. If I use sum (Sales) I'll have 310, instead I would like to have Jan 110, Fabr 160 etc.

Thank you very much!

Re: Sum for different months

Anil_Babu_Samineni — Fri, 20 Oct 2017 13:01:51 GMT

Why Fabruary 160?? Can you make clear output?

Re: Sum for different months

jonathandienst — Fri, 20 Oct 2017 13:03:26 GMT

>>instead I would like to have Jan 110, Fabr 160 etc.

If you use Months as a dimension and Sum(Sales) as the measure, that's precisely what you will get.

Edit: assuming Feb is missing a line...

Re: Sum for different months

Anil_Babu_Samineni — Fri, 20 Oct 2017 13:06:45 GMT

Addition we need to add Month(Date#(Months,'MMM'))

Re: Sum for different months

a_brancati — Fri, 20 Oct 2017 13:10:53 GMT

Hi Jonathan! Sorry, yes the output was 160. I would like to have one bar with all the monthly misures on one bar, so I can't put the month for dimension.

Thank you.

Re: Sum for different months

Anil_Babu_Samineni — Fri, 20 Oct 2017 13:20:44 GMT

Are you not looking this? If not, Can you make paper diagram

Re: Sum for different months

Anonymous — Fri, 20 Oct 2017 13:30:13 GMT

Try the attached QVW

Re: Sum for different months

a_brancati — Fri, 20 Oct 2017 14:30:25 GMT

Re: Sum for different months

lorenzoconforti — Fri, 20 Oct 2017 20:48:07 GMT

Hi Anna, you just need to set the style in your chart as stacked and add a second dimension for month. Maybe if you post your application it would be easier to help

Re: Sum for different months

Anonymous — Mon, 23 Oct 2017 12:47:29 GMT

Stacked bar charts need either; two dimensions, one expressions OR one dimension, multiple expressions.

I have attached an example where I added a new field "Year" and have 2 years of data. the stacked chart now shows the 2 years figures combined in a stacked chart.

Re: Sum for different months

a_brancati — Mon, 23 Oct 2017 15:23:07 GMT

Yes, thank you Aron, your example was very useful!

Re: Sum for different months

Anonymous — Mon, 23 Oct 2017 15:38:50 GMT

OK so I thought about it for a second and made the attached which is what you want I believe.

This time it uses "Year" for the stacked bar and "Month" for the data segments