topic Re: Total Column in QlikView

Total Column

Thu, 06 Sep 2012 16:07:15 GMT

Hello,

I wisht to creat a colum that sums the total cuantity from de rows before.

Thank you

An example:

Header 1	January	February	Total
Article 1	10	10	20
Article 2	10	10	20
Article 3	10	10	20

Re: Total Column

Thu, 06 Sep 2012 16:12:28 GMT

Go to presentation tab, select partial sums for dimension month. If these are all expressions then just add them together

Re: Total Column

Thu, 06 Sep 2012 16:27:23 GMT

Hi Diego,

Thanx a lot for your reply.

I think this solution does not meet my expectations. I´m working with a Pivot Chart Table. Header 1 and Month are both Dimensions (Month Dimension has been moved over The expresion) Is there any way of having a Totals column ? the problem with partial sums is that I have a row not a column.

Anyone has ideas ¿?

Re: Total Column

pgalvezt — Thu, 06 Sep 2012 16:54:37 GMT

In presentantion Tab - Show Partial Sum.

Re: Total Column

whiteline — Thu, 06 Sep 2012 16:59:32 GMT

Hi diegogarrido,

why didn't you even try what marcsliving suggested ?

There is no problem to have that totals and he said you how to achive it ('Partial Sum' for month dimension). You can have sub totals for every dimension wether it horizontal or vertical.

Re: Total Column

Fri, 05 Oct 2012 12:05:49 GMT

I have your exact same problem. Did you solve it?