Discussion Board for collaboration related to QlikView App Development.
No of Reps
MAT VAL Aug-14
We Want to calculate Sale Like this
METHYCAL TABLETS 15'S
HYDERABAD - 1 ABM
HYDERABAD - 2 ABM
HYDERABAD - 3 ABM
Please refer this table presently we are calculating sales on HQ Level (Gross Sales – Sales Return) at the lowest level , We have created hierarchy
in qlikview for rolling up this sales to upper level ie. HQ2 (RM-Level). When we insert dimension HQ2 in report in report -> 32 sales is repeating
3 times but actually this sales should divide as per rmcount in given table (11+8+13) = 32 will be sale for RM . I am stuck in logic how to implement
the same in Qlikview so need your assistance how to incorporate this logic in Qlikview.