Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi,
Enable partial Sum in option in Presentation tab.
Regards,
Jagan.
thank you
Hi,
If you got the solution, please close this thread by giving Correct and Helpful answers to the useful posts.
Regards,
Jagan.
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..
Can you give me another example, I'm interested that way
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