topic Re: sum total sales in QlikView

sum total sales

tomer1984 — Tue, 19 Jan 2016 12:43:06 GMT

I created a straight table with 3 dimensions (Worker Name ,ID , WRH ) in order to calculate the employee evaluation bonus

the evaluation bonus = (monthly branch sales)*(manger's employee evaluation - percentage)

as follows :

I have an issue with the sum expression of the monthly branch sales ,

i am not sure what to use...

as the example table above :

i would like the sum branch sales field to consist all the sales of the employees from the same branch ,

3000

30%

5000

1500

5000=3000(sales -B)+2000( sales-C)
can someone assist ?

swuehl — Tue, 19 Jan 2016 15:28:24 GMT

Try the TOTAL qualifier in the Sum() function:

=Sum(TOTAL<WRH> SALES)

tomer1984 — Wed, 20 Jan 2016 10:11:37 GMT

it worked.

many thanks

Wed, 20 Jan 2016 15:26:17 GMT

TOTAL Qualifier ignores the Dimension values in the chart object.

Try Sum( TOTAL <WRH> SALES).

Please mark the question as Correct answer so that will help to others.