topic Re: Data values Problem in QlikView

Data values Problem

krishna20 — Sun, 03 Aug 2014 11:54:42 GMT

Hi Friends,

There is a problem in data. The amount in the database(Oracle) and to Qvw file is not matching for individual companies.But, the total amount is showing as correct. I took Company name as Dimension and in expression sum(Amount).I reloaded the whole three tier applications.But,the problem is not rectified.Anyone pls help me out,what may be the problem is.?

Regards

Krishna

Re: Data values Problem

Yousef_Amarneh — Sun, 03 Aug 2014 12:08:16 GMT

check the link between your tables in the data model

Re: Data values Problem

aveeeeeee7en — Sun, 03 Aug 2014 12:35:03 GMT

Try any one of the below expressions.

1. Sum(Aggr(sum(Amount),CompanyName))

2. Sum(<CompanyName>Amount)

If these doesn't work than check your Data Model Linking. Joins sometimes cause problems. Check the Joins you have used in the Application - Left Join, Right Join, etc...

Hope that helps you.

Regards

Aviral Nag

Re: Data values Problem

krishna20 — Sun, 03 Aug 2014 12:52:57 GMT

Dear Nag,

Thank u for your valuable reply.

No changes after applying the above expression.

Regards

Krishna

Re: Data values Problem

aveeeeeee7en — Sun, 03 Aug 2014 12:55:19 GMT

Kindly Attach your qvw here.

Re: Data values Problem

avinashelite — Sun, 03 Aug 2014 17:27:40 GMT

Hi Kalyan,

According to your explanations your getting the Total Sum as correct but individual company Total is incorrect rite!!!!

According to me their may be multiple records which are having same data like

Company,Amount,Date

A,100,26-06

if so Qlikview will treat it as a single record and the sum will varies. Please check whether your facing any such situation. If not as said by Nag Aviral please attach your app.

Regards,

@vi

Re: Re: Data values Problem

krishna20 — Sun, 03 Aug 2014 17:53:45 GMT

Hi Nag,

I'm attaching the datamodel file here .pls check it and guide me further.I think there is a problem in datamodelling.

Regards

Krishna

Re: Data values Problem

krishna20 — Mon, 04 Aug 2014 04:20:02 GMT

Hi Avinash,

how to find if the duplicate values are there.?Pls find the above attachment i have mentioned my problem in the above application.

Regards

Krishna

Re: Data values Problem

ashfaq_haseeb — Mon, 04 Aug 2014 05:23:09 GMT

Hi Kalyan,

Your document is not accessible.

I think you have to do some aggregation.

Regards

ASHFAQ

Re: Data values Problem

krishna20 — Mon, 04 Aug 2014 05:31:39 GMT

Hi Ashfaq,

I did aggregate also,But same result.

Regards

Krishna

Re: Data values Problem

ashfaq_haseeb — Mon, 04 Aug 2014 05:33:22 GMT

Hi,

Can you attach your app again. Its corrupted.

Regards

ASHFAQ

Re: Data values Problem

krishna20 — Mon, 04 Aug 2014 05:34:19 GMT

i checked in straight table by taking calculated dimension if(CS_COMP_CODE='001' or CS_COMP_CODE='002'...........) and expression as SUM(CS_AMT_LC_1).

The total in DB and QVW is 3813767227

COMP_CODE : 001 total in DB is 1836772815.773

but i'm getting value for COMP_CODE : 001 is 1569389285.213

Regards

Krishna

Re: Data values Problem

avinashelite — Mon, 04 Aug 2014 06:14:45 GMT

Hi Kalyan,

I am not able to download the document?? how many MB file it is ?? its going beyond 40MB+

Re: Data values Problem

krishna20 — Mon, 04 Aug 2014 06:20:51 GMT

Hi Avinash,

Its a 260MB file avinash.I'm uploading total file for you to guide me.

Regards

Krishna

Re: Data values Problem

avinashelite — Mon, 04 Aug 2014 06:44:31 GMT

Hi Krishan,

Use rowno() over CLM_Settlement table and check the data once.

like load ...,

Rowno() as serial_no

from qvd....

Re: Re: Data values Problem

krishna20 — Mon, 04 Aug 2014 08:43:37 GMT

Hi Ashfaq,

Pls find the below attachment and guide me further.Its very urgent,please do the needful.

Regards

krishna