I have big tables data with have many dimensions (as Dim1, Dim2, Dim3....) and have many columns of quantity and amount columns.
Format is as below:
Dim1
Dim2
Dim3
Quantity
Amount
Battery
Import
1001
10
100
RML
Import
1001
20
200
Radio
Import
1001
30
300
Battery
Domestic
1001
40
333
RML
Domestic
1001
5
444
Radio
Domestic
1001
7
222
Battery
Import
1002
8
111
RML
Import
1002
9
654
Radio
Import
1002
11
78
Battery
Domestic
1002
10
54
RML
Domestic
1002
55
32
Radio
Domestic
1002
44
45
Now I wants to show the data in below mentioned form:
Dim
Sum of Actual
formula (only for understanding)
Battery Quantity
68
sum of Qty
Battery Quantity (Domestic)
50
sum of Qty
Battery Quantity (Import)
18
sum of Qty
RML Quantity
89
sum of Qty
RML Quantity (Domestic)
60
sum of Qty
RML Quantity (Import)
29
sum of Qty
Radio Quantity
92
sum of Qty
Radio Quantity (Domestic)
41
sum of Qty
Radio Quantity (Import)
51
sum of Qty
Battery Rate (Domestic)
7.74
Sum of Amount/Sum of Qty
Battery Rate (Import)
11.72
Sum of Amount/Sum of Qty
Kindly suggest how to get this format in qlikview.
I cannot use crosstable or any other table formation methods because data is too big. Wanna changes in front end with the help of mapping from excel or through expression.
