calculations of columns

[#1]

I have this column  that appears in the image

and I want to get the total of all columns

tipo                                       total

1      42+72+48+93  =         255 

2       87+2+47+75    =        211

3        86+35+3+61  =         185

another column with the values of total

[sushil353 · Accepted solution]

Hi,

If this is your pivot table in QlikView then simply enable the partial sum in presentation tab.

If this is your source table then you can load this data into QlikView as crosstable load .. for more info on crosstable load you can refer QlikView help.

HTH

Sushil

[jagan]

Hi,

Enable partial Sum in option in Presentation tab.

Regards,

Jagan.

[#4]

thank you

[jagan]

Hi,

If you got the solution, please close this thread by giving Correct and Helpful answers to the useful posts.

Regards,

Jagan.

[vinay_hg]

easy way, create one more expression

if ur colulmn names are A,B,C,D

then create new expression =A+B+C+D name it as total.. u can use expression name also for calculation..

[#7]

Can you give me another example, I'm interested that way

[vinay_hg]

may be u have

expression 1 as = sum(sales amount) // expression name =sales

expression 2 as = count(oppurtunities) // expression name = oppcount

if u want to calculate avg per oppurtunity (usally this scenario will not araise in sales)

expression 3 = sum(sales amount)/count(oppurtunities)

or

expression 3 = sales/oppcount      // as sales & oppcounts are expression names. this will work also