Same script not working

[vikas_nandanwar]

Hi,

I am loading data from 2 sheets with same columns

Sheet 1 - Parcel

Sheet 2 - Certified

Sum in the certified sheet is not calculating correctly.

Please help.

Thanks,

Vikas

[tresesco]

If you could share your data and qvw to demonstrate the issue, we may have a look into the issue and help.

[vikas_nandanwar]

how to upload script or app here

[tresesco]

Read these:

Uploading a Sample

Qlik Community Tip: How to Get Answers to Your Post

and when your issue is resolved:

Qlik Community Tip: Marking Replies as Correct or Helpful

[Anil_Babu_Samineni]

What you mean not calculating Correctly, Can you attach image atleast from excel and in Qlikview?

[vikas_nandanwar]

Hi,

attaching my data file and qlik file

[tresesco]

Now, quickly let know where do I look for the issue. Which excel column and which data point in the qvf should I look at to notice the issue.

[vikas_nandanwar]

Cts and Sales

[tresesco]

Your data model has many synthetic keys. You probably need to remove them.