Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
fungcheung
Partner - Contributor II
Partner - Contributor II
‎2019-09-13 03:06 AM

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

  

Preview file
12 KB
sample.qvw
1,710 Views
0 Likes
10 Replies
asinha1991
Creator III
Creator III
‎2019-09-13 03:14 AM

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

1,580 Views
0 Likes
fungcheung
Partner - Contributor II
Partner - Contributor II
‎2019-09-13 03:22 AM
Author

In response to asinha1991

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

1,572 Views
0 Likes
asinha1991
Creator III
Creator III
‎2019-09-13 03:28 AM

In response to fungcheung

can you share your expression?

1,564 Views
0 Likes
fungcheung
Partner - Contributor II
Partner - Contributor II
‎2019-09-13 03:29 AM
Author

In response to asinha1991

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

1,561 Views
0 Likes
StarinieriG
Partner - Specialist
Partner - Specialist
‎2019-09-13 03:30 AM

Hi,

add Personalnformation.Birthday inside aggr

1,557 Views
0 Likes
fungcheung
Partner - Contributor II
Partner - Contributor II
‎2019-09-13 03:35 AM
Author

In response to StarinieriG

Dear StarinieriG,

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

 

1,548 Views
0 Likes
maxronny
Contributor III
Contributor III
‎2019-09-13 03:36 AM

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
file.qvw
1,544 Views
0 Likes
fungcheung
Partner - Contributor II
Partner - Contributor II
‎2019-09-20 04:03 AM
Author

In response to maxronny

hi,

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

 

 

1,457 Views
0 Likes
florentina_doga
Partner - Creator III
Partner - Creator III
‎2019-09-20 08:33 AM

pls see atash

sample-22.qvw
1,437 Views