Hi sum of value issue when load all excel files into qlikview

[Anonymous]

HI all,

                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 .

regards,

Gireesh

[sunny_talwar]

The attached qvw is empty and I am not sure I follow you issue, can you elaborate on the problem you are facing?

[Anonymous]

i tried to open all the files and what you have asked does not tie together. can you please provide more details

[MK9885]

The XL files which you provided gives sum as

22073989

and

11361887217

None of the XL sum matches with what you looking for.

Please check you XL files again. qlik view is providing sum as per XL.

[Anonymous]

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.

Regards,

Gireedh.

[varshavig12]

As I'm using P.E , I cannot open your qvw.

Although, I got this after loading 3 files

[jonathandienst]

Your app gives the following totals:

I cannot replicate your numbers.