when i load each excel file the sum correct and if i load files all into one qvw i'm not getting correct sum. below i'm attaching sample qlikview and excel files, but all excel files having same fields .
qlikview out put below
below i am sharing sample qlik and excel files please regarding get correct sum of net price and quantity in qlikview .
Hi all ,
when i load the each excel file separately into qlikview sum is correct, but if load 3 excel files into qlikview and if do the sum not matching sum of excel not equal to qlikview . i'm attaching my qlikview sample document, please check once.
Your app gives the following totals:
I cannot replicate your numbers.