Data values Problem

[krishna20]

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

[Yousef_Amarneh]

check the link between your tables in the data model

[aveeeeeee7en]

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

[krishna20]

Dear Nag,

Thank u for your valuable reply.

No changes after applying the above expression.

Regards

Krishna

[aveeeeeee7en]

Kindly Attach your qvw here.

[avinashelite]

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

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 

[krishna20]

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

[krishna20]

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

[ashfaq_haseeb]

Hi Kalyan,

Your document is not accessible.

I think you have to do some aggregation.

Regards

ASHFAQ

[krishna20]

Hi Ashfaq,

I did aggregate also,But same result.

Regards

Krishna