topic Re: sum total column in QlikView

sum total column

Anonymous — Sun, 26 Jan 2014 05:07:59 GMT

hi,

can i do in pivot sum total for column ? sum(total(coulm(14)))

i meen i had columns that show the result for diffrents columns ( i can't make sum total for that - it's to comliceted )

thanks'

yarin.

brindlogcool — Sun, 26 Jan 2014 05:34:15 GMT

You can do it using the set Analysis. ---sum( {1} Total Sales ). Check the reference manual/Help option for more option,

MK_QSL — Sun, 26 Jan 2014 09:20:58 GMT

Go to the Presentation Tab and Select Partial Sum.

Hope this will help.

If your problem still not solved, please upload you sample file.

Sun, 26 Jan 2014 09:32:52 GMT

You can use already created expressions in other expressions you create.

Like suppose if you have:

column14 = aggr(sum(TestData),Category)

Then

Column15 can use column 14 like

=aggr(column14,Product)

Is this what you expect?

Hope it was helpful or let me know if any other questions you have

israrkhan — Sun, 26 Jan 2014 09:37:10 GMT

i think you cant do it,

because Column(14), mean the display value. total will not affect it.

but you can copy the expression from column 14 and add total on it, so it will work..

Anonymous — Sun, 26 Jan 2014 14:36:18 GMT

Hi Yarin,

You and get total for a column with below expressions
=sum(Column14)

=sum({1} Column14)