Hello Expert,
I have a request like this one:
The sales region is hierarchy and the report will show the sales rep count under the selected region.
The sales rep supposed to upload in DELTA and for sales region again it is a DELTA.
Given the initial data like this one:
NodeID | ParentID | NodeName |
---|
1 | 1 | All |
2 | 1 | A |
3 | 1 | B |
4 | 2 | AA |
NodeID | Sales rep count
|
---|
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
When we look the sales rep count under region A, the total count is:
Count under A = sales rep directly under A + sales rep count indirectly under A
In above case:
Count under A = 2 + 4 = 6
Above is the initial load of data. When the delta comes:
NodeID | ParentID | NodeName |
---|
5 | 2 | AB |
6 | 2 | AC |
NodeID | Sales rep count
|
---|
5 | 5 |
6 | 6 |
Count under A = 2 + 4 + 5 + 6 = 17
In QlikView, it is quite a question for me because:
1). Does QlikView support DELTA load?
2). Given the DELTA load is support, when we load the hierarchy, the structure is dynamic(initial load will generate 3 NodeName fields while the DELTA load will generate two more NodeName fields), how should we apply this in the chart structure? Or how can the chart(say pivot table) know the changes of NodeName fields?
Appreciated for any comment!
HTC