Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
tomer1984
Contributor III
Contributor III

sum total sales

Hi


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 :

worker name

ID

WRH

SALES

mangers evaluation

BRANCH _TOTAL _SALES

BONUS

A

1

25

1000

30%

1000

300

B

2

32

2000

10%

5000

500

C

3

32

3000

30%

5000

1500

D

4

57

500

15%

1500

225

E

5

57

1000

85%

1500

1275

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 ,

 

C

3

32

3000

30%

5000

1500


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



1 Solution

Accepted Solutions
Not applicable

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.

View solution in original post

3 Replies
swuehl
MVP
MVP

Try the TOTAL qualifier in the Sum() function:

=Sum(TOTAL<WRH> SALES)

tomer1984
Contributor III
Contributor III
Author

it worked.

many thanks

Not applicable

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.

View solution in original post