topic Re: Using Total of Column in an Expression in QlikView

Using Total of Column in an Expression

dthornburg — Thu, 09 Jan 2014 20:23:38 GMT

Hi,

I have a straight table with a total column that is calculated with the following expression:

Column (3) + Column (4) + Column (5). I attached the straight table. I am trying to add one more column that uses the Total of the calculated column divide by the total of the line. This would give a percentage of the total. Example:

1623919.8 / 9391684.39 * 100 = 17.29%

301618.59 / 9391684.39 * 100 = 3.2 %

etc.

The issue I am having is getting the total of the column(9391684) in my expression. Any ideas? Seemed simple but I am missing something.

Re: Using Total of Column in an Expression

martin59 — Thu, 09 Jan 2014 21:06:34 GMT

Hi Dick,

What is the expression of your sixth column ?

You have to add the TOTAL keyword to obtain the result.

For exemple, if your expression is sum(TurnOver) for the 6th column.

You just have to write something like this

(Column (3) + Column (4) + Column (5)) / Sum(TOTAL TurnOver) *100

Hope that helps you

Martin Favier

Re: Using Total of Column in an Expression

Thu, 09 Jan 2014 21:35:25 GMT

Hi,

Hope this is what you are looking for.

Please take a look at the Expression '%'. I have used sum as an example. Hope it works for your case as well.

Let me know if it doesn't meet your needs.

Thanks

Re: Using Total of Column in an Expression

dthornburg — Fri, 10 Jan 2014 13:43:42 GMT

Hi,

Neither one of these are giving me a result.

Current calculation is below just trying to simplify :

Column (6) / sum(total E)

6th Column calculation is - Column (3) + Column (4) + Column (5).

I do have the Totals printing at the top. They are in bold. I want to use that total of column 6 in the calculation.

Thanks for the quick response.

Re: Using Total of Column in an Expression

preminqlik — Fri, 10 Jan 2014 13:49:16 GMT

hi Duck ,

Try this

(column(1)+Column(2)+Column(3))sum(total aggr((column(1)+Column(2)+Column(3)),Dimension1,Dimension2)

try this and let me know , if not getting try using each and every column by aggr()

Re: Using Total of Column in an Expression

martin59 — Fri, 10 Jan 2014 17:23:54 GMT

Hi Dick,

Could you send us a sample of your QV app or your expression for the sixth column ?

Thanks in advance,

Martin Favier