topic Re: How do I use an expression column total in Row calculation in QlikView

How do I use an expression column total in Row calculation

Thu, 25 Oct 2012 16:16:59 GMT

I am new to Qlik view so this question may be basic but I have not found anything that works

I have created a Straight table that has

Demension A, B, C and

Expressions D, E, F

What I need to do is use the Average of all values in column F as part of a calculation to create new column G..

If I were doing this in a spreadsheet Cell G2 it would look like this: "=D2 - SUM(F:F)", Cell G3 would be "=D3 - SUM(F:F)", etc

Any help is appreciated

Re: How do I use an expression column total in Row calculation

Gysbert_Wassenaar — Thu, 25 Oct 2012 16:59:13 GMT

You can't use other columns like that in expressions. You have to use the fields in expression. Here I create three columns D,E and F that all three use field Sales in an expression. F calculates the sum(Sales) divided by the overall average of Sales over all dimensions.

😧 sum(Sales)

E: avg(Sales)

F: sum(Sales)/avg(total Sales)

I hope this helps you figure out how to achieve what you need.

Re: How do I use an expression column total in Row calculation

Thu, 25 Oct 2012 22:11:02 GMT

Thank You much - The problem was it was too simple. I was looking for a complicated answere when all I needed was the "Total" function.

Thanks for your help