Solved: Re: How to summary data same excel? - Qlik Community

panwipa2528 · ‎2017-10-20

I summary data from qlikview as green part but result is not true, how to I got result same as excel summary?

Anil_Babu_Samineni · ‎2017-10-20

May be Ceil(Sum(Sales))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

petter · ‎2017-10-20

For me QlikView calculates 39987 for the integer part not 39986 as you have.... do you have a sample QlikView app to share so we can find out why your calculation doesn't add up to 39987?

Anil_Babu_Samineni · ‎2017-10-20

May be Ceil(Sum(Sales))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

marcus_malinow · ‎2017-10-20

How about Sum(Ceil(Sales))