topic Re: Same script not working in QlikView

Same script not working

vikas_nandanwar — Thu, 14 Dec 2017 05:01:11 GMT

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

tresB — Thu, 14 Dec 2017 05:12:14 GMT

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

vikas_nandanwar — Thu, 14 Dec 2017 05:21:02 GMT

how to upload script or app here

tresB — Thu, 14 Dec 2017 05:31:14 GMT

Read these:

and when your issue is resolved:

Anil_Babu_Samineni — Thu, 14 Dec 2017 05:32:52 GMT

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

vikas_nandanwar — Thu, 14 Dec 2017 05:56:55 GMT

Hi,

attaching my data file and qlik file

tresB — Thu, 14 Dec 2017 06:06:50 GMT

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 — Thu, 14 Dec 2017 06:07:43 GMT

Cts and Sales

tresB — Thu, 14 Dec 2017 06:15:45 GMT

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