Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
fungcheung
Partner
Partner

Incorrect Partial Sum in Pivot Table

We design to create a pivot table with total at the bottom, however, the total is incorrect. Is there any suggestion on the expression with correct data displayed?

 

Actual Result:

sample01.JPG

 

Expected Result:

sample02.JPG

  

10 Replies
asinha1991
Creator III
Creator III

do you have duplication in actual data for combination of cost center and value? it will not show in rows but in total everything adds up

fungcheung
Partner
Partner
Author

Would you suggest any expression that we can only adds up the data showing in the rows instead of everything, thanks. 

asinha1991
Creator III
Creator III

can you share your expression?

fungcheung
Partner
Partner
Author

I have already attached the sample qvw file, please check it. Thanks.

StarinieriG
Partner
Partner

Hi,

add Personalnformation.Birthday inside aggr

fungcheung
Partner
Partner
Author

Dear StarinieriG,

Sorry, I try to add PeronsalInformation.Birthday inside aggr but it still not work.

 

maxronny
Contributor III
Contributor III

please find the file.qvw with the solution.

 

best regards.

 

Cost CenterSum (前線)Sum (後勤)Sum(Total)
10,003,673,67
20,009,759,75
50,003,333,33
60,003,803,80
70,006,676,67
90,004,944,94
100,009,009,00
110,009,509,50
120,005,505,50
140,006,096,09
150,005,505,50
180,007,887,88
230,009,009,00
250,002,502,50
280,0012,0012,00
290,002,002,00
440,005,005,00
600,004,004,00
1075,000,005,00
1086,000,006,00
10912,000,0012,00
1115,670,005,67
1137,000,007,00
1147,330,007,33
1165,000,005,00
11713,000,0013,00
1253,750,003,75
1308,000,008,00
1343,000,003,00
1368,200,008,20
1381,500,001,50
14112,000,0012,00
1438,500,008,50
1457,430,007,43
1466,000,006,00
1606,500,006,50
1617,200,007,20
1628,000,008,00
1707,500,007,50
1729,000,009,00
1731,000,001,00
1745,000,005,00
17512,000,0012,00
18111,000,0011,00
1823,000,003,00
1845,500,005,50
1879,000,009,00
1896,750,006,75
1904,000,004,00
1926,670,006,67
2104,290,004,29
21116,000,0016,00
2159,000,009,00
22210,000,0010,00
2259,000,009,00
2303,000,003,00
23113,000,0013,00
2324,000,004,00
2335,000,005,00
2348,000,008,00
24014,000,0014,00
2416,000,006,00
2436,000,006,00
2457,000,007,00
2466,000,006,00
4010,004,004,00
4610,0011,0011,00
Totale341,78125,13466,91
fungcheung
Partner
Partner
Author

hi,

the excel should be the expected output of qlikview, it is not a datasource for the case. Thanks.

 

 

florentina_doga
Partner
Partner

pls see atash