topic Re: Sum Total Column() in QlikView

Sum Total Column()

Anonymous — Fri, 04 Mar 2016 20:02:43 GMT

Hi All,

It is possible to sum a column()?

For example:

Column(1) - is equal to =Column(2) + Column(3)

With column(4) , I want to sum total column(1) * percentage.

I tried with =Sum(Total column(1)) * Percentage, this didn't work.

Many Thanks,

Frank

Re: Sum Total Column()

Fri, 04 Mar 2016 20:07:06 GMT

seria isso que está procurando?

se não for, poste o arquivo para melhor entendimento!

Re: Sum Total Column()

Anonymous — Fri, 04 Mar 2016 20:41:30 GMT

didn't work...

Re: Sum Total Column()

Anonymous — Fri, 04 Mar 2016 21:01:59 GMT

Hi, not sure what you are trying to do, but why not something like?

column 4 = (sum([Field_Column_2]) + sum([Field_Column_3])) * percentage

If what you need is the fixed total from column 1, could also store the total sum from Column2 and Column3 into a variable and then multiply that by the percentage field to get column4.

Re: Sum Total Column()

Digvijay_Singh — Sat, 05 Mar 2016 08:58:52 GMT

AFAIK Sum function doesn't work with column as it expects real expression. See if this sample can help.