topic Re: Cumulative Total by User, Stacked Bar Chart in QlikView

Cumulative Total by User, Stacked Bar Chart

fosterma — Tue, 12 Apr 2016 11:55:43 GMT

Hi All,

I'm attempting to create a stacked bar chart as attached drawing.

I have 'Invoice Date' as a dimension displayed as Month Year and I'm trying to show Total Amount accumulated by user per month as an expression.

I've defined it as follows, but I'm not getting the desired results. I'm Probably going about it the wrong way.

=aggr(Sum({$<[Invoice Year]={"$(=Max([Invoice Year]))"}>}[Total Amt.]), [User Name]))

Example Data:

Invoice Date | Department | User | Total Amt. |

01/01/2016 | Operations | User A | £10

01/01/2016 | Operations | User B | £15

01/01/2016 | IT | User C | £30

01/02/2016 | Operations | User A | £20

01/02/2016 | Operations | User B | £10

01/02/2016 | IT | User C | £10

Can anyone help point me on the right path?

Thanks,

Re: Cumulative Total by User, Stacked Bar Chart

ariel_klien — Tue, 12 Apr 2016 12:21:38 GMT

Hi,

please see the attachment.

is that what you are looking for?

Ariel

Re: Cumulative Total by User, Stacked Bar Chart

sunny_talwar — Tue, 12 Apr 2016 12:22:37 GMT

Like this?

Re: Cumulative Total by User, Stacked Bar Chart

fosterma — Tue, 12 Apr 2016 12:51:17 GMT

Yes, I think so Sunny

So the end result would look like as below but split by user for each month as you have above

Re: Cumulative Total by User, Stacked Bar Chart

sunny_talwar — Tue, 12 Apr 2016 13:00:05 GMT

Right now we only have one month of data that you have provided. I guess can you try the above example on your end and see if this is working for you or not?

Re: Cumulative Total by User, Stacked Bar Chart

fosterma — Wed, 13 Apr 2016 07:45:40 GMT

Thanks Sunny