Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total Column

Hello,

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

Thank you

An example:

Header 1JanuaryFebruaryTotal

Article 1

101020
Article 2101020
Article 3101020
5 Replies
Not applicable
Author

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

Not applicable
Author

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

pgalvezt
Specialist
Specialist

In presentantion Tab - Show Partial Sum.

whiteline
Master II
Master II

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.

Not applicable
Author

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