Discussion Board for collaboration related to QlikView App Development.
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 :
BRANCH _TOTAL _SALES
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 ,
5000=3000(sales -B)+2000( sales-C) can someone assist ?
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
Try the TOTAL qualifier in the Sum() function: