Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh007
Contributor III
Contributor III

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

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 .

netprice.PNG   

qlikview out put below

qliknetprice.PNG      below i am sharing sample qlik and excel files please  regarding  get correct sum of net price and quantity in qlikview .

regards,

Gireesh

6 Replies
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?

vinay_bangari
Specialist III
Specialist III

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

MK9885
Master II
Master II

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.

gireesh007
Contributor III
Contributor III
Author

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
Specialist
Specialist

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

Although, I got this after loading 3 files

jonathandienst
Partner - Champion III
Partner - Champion III

Your app gives the following totals:

Capture.PNG

I cannot replicate your numbers.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein