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: 
vikasmahajan
Champion
Champion

Roll Up Hierarchy Wise Sales in Qlikview

Dear all,

Product

HQ

HQ2

No of Reps

Rmcount

MAT VAL
Aug-14

We Want to calculate Sale Like this

METHYCAL TABLETS 15'S

Total

32

32

METHYCAL TABLETS 15'S

HYDERABAD POOL

HYDERABAD - 1 ABM

12

4

32

11

METHYCAL TABLETS 15'S

HYDERABAD POOL

HYDERABAD - 2 ABM

12

3

32

8

METHYCAL TABLETS 15'S

HYDERABAD POOL

HYDERABAD - 3 ABM

12

5

32

  1. 13.33333333

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.

Thanks

Vikas

0 Replies