topic Re: Sum(Sales) vs sum(total sales) in QlikView

Sum(Sales) vs sum(total sales)

Mon, 27 Aug 2012 05:40:15 GMT

Hi everyone,

Can anyone here explain the difference between sum(sales) vs sum(total sales) with an example?

Many thanks,

Murali

Re: Sum(Sales) vs sum(total sales)

its_anandrjs — Mon, 27 Aug 2012 05:49:59 GMT

Hi,

I explain with an example like:-

ColA, Value

A, 200

B, 300

C, 400

1. so If you take a chart with expression Sum(Value)

Dimension: ColA and

Expression: Value

it will shown

200 , 300 , 400

2. If you create a chart with expression Sum(Total value)

Dimension: ColA and

Expression: Value

it will shown 900 for all values for A,B,C

Thanks & Rgds

Re: Sum(Sales) vs sum(total sales)

jonathandienst — Mon, 27 Aug 2012 06:32:22 GMT

The TOTAL keyword causes the dimensions to be ignored. You can also qualify the total to ignore specific dimensions. If you have a chart/table with dimensions Dim1 and Dim2 then

Sum(Total Sales) will ignore both dimensions (but will respect any selections you have made)

Sum(Total <Dim2> Sales) will show the total Sales by Dim1, ignoring Dim2

Hope that helps

Jonathan

Re: Sum(Sales) vs sum(total sales)

Mon, 27 Aug 2012 06:46:07 GMT

Thanks for your help.

Regards,

Murali

Re: Sum(Sales) vs sum(total sales)

Fri, 04 Apr 2014 02:38:39 GMT

Sorry, I think for: "Sum(Total <Dim2> Sales)" will show the total Sales by Dim2, while ignoring Dim1.

Sales will be returned for each combination of field values in the listed dimension fields.

Re: Sum(Sales) vs sum(total sales)

Fri, 04 Apr 2014 02:51:11 GMT

Hi,

Inline table 1:

A, 50

B, 50

C, 200

sum(sales) will result in the total being sum(sales for A,B,C) which is 300

If you want to do A/(A+B+C), use total.

Re: Sum(Sales) vs sum(total sales)

Sat, 13 Sep 2014 11:47:12 GMT

Hi,

I explain with an example like:-

ColA, Value

A, 200

B, 300

C, 400

1. so If you take a chart with expression Sum(Value)

Dimension: ColA and

Expression: Value

it will shown

200 , 300 , 400

2. If you create a chart with expression Sum(Total value)

Dimension: ColA and

Expression: Value

it will shown 900 for all values for A,B,C

Thanks & Rgds