topic Re: How to calculate totals across a row? in QlikView

How to calculate totals across a row?

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

Hi everybody!

I have a pivot table with data and i would like to have a total for the rows

Month T-shirts jeans hoodies Month Total

Jan 300 300 300 900

Feb 400 430 420 850

Mar 500 500 500 1500

How do i calculate the "Month Total"? as an expression in a pivot table guys?

Re: How to calculate totals across a row?

vishsaggi — Wed, 17 May 2017 16:17:25 GMT

Pivot table chart properties -> Presentaion tab -> Check Show partial sums for Month Dim.

Re: How to calculate totals across a row?

hcabrera — Wed, 17 May 2017 16:19:31 GMT

Hi,

if T-shirts, jeans and hoodies are expressions you can create other expresion named Month Total = [T-shirts] + [jeans] + [hoodies]

Re: How to calculate totals across a row?

aaronnayan — Wed, 17 May 2017 16:22:46 GMT

Hi Vishwarath

when i click show partial sums it give me the totals for the expressions in the coloums not the rows?

Month T-shirts jeans hoodies Month Total

Jan 300 300 300 ???

Feb 400 430 420 ???

Mar 500 500 500 ???

Re: How to calculate totals across a row?

vishsaggi — Wed, 17 May 2017 16:37:20 GMT

Is this pivot table? If yes, just add your dimensions and expr as

Dim : Month, Tshirts, Hoodies, Jeans

Expr:

= Tshirts + Hoodies + Jeans

Re: How to calculate totals across a row?

shiveshsingh — Wed, 17 May 2017 17:03:59 GMT

use below expression

aggr(sum (Value),Month)

you will get the sum ..group by month..

Re: How to calculate totals across a row?

trdandamudi — Wed, 17 May 2017 17:12:42 GMT

If your data is like below then you no need to create any extra columns with formulas:

Data:
Load * Inline [
Month,Type,Amount
Jan,T-shirts,300
Jan,Jeans,300
Jan,hoodies,300
Feb,T-shirts,400
Feb,Jeans,430
Feb,hoodies,420
Mar,T-shirts,500
Mar,Jeans,500
Mar,hoodies,500
];