Like this to produce some type of PERFUMES we may need 7 assembled items and components, some of the assembled items are common for lots of perfumes, means an assembled item can be a part of any perfume
Our ERP system has kept data in above format for all the items in a single table
Now we need a report in qlikview for costing, more are like below mentioned format, this is a basic requirement, later on this report may complex because, we may link stock avail and purchase, etc…
Product code
Level
Assembled item
Compoonent code
Type of item(A - Assembled, B - Non Assembled)
Usage quantity
cost
Value
ABCDEFGH
1
ABCDEFGH
A
B
0.5
10
5
ABCDEFGH
1
ABCDEFGH
B
A
1
5
5
ABCDEFGH
1
ABCDEFGH
C
B
0.25
20
5
ABCDEFGH
1
ABCDEFGH
D
B
0.25
25
6.25
TOTAL
21.25
ABCDEFGH
2
B
D
A
0.7
100
70
ABCDEFGH
2
B
E
B
0.3
20
6
TOTAL
76
ABCDEFGH
3
D
G
B
0.5
15
7.5
ABCDEFGH
3
D
H
B
0.2
20
4
TOTAL
11.5
PRODUCT TOTAL
108.75
There is one command in qlikview called Hierarchy which Is meeting bit of my requirement, but still total and sub total of cost is not accurate, if somehow I can load in above format then I will achieve my goal, please help
I have attached my qliiview report which designed using hierarchy command
