Having trouble with the count() function

[Anonymous]

Hi, QlikView community

I have trouble with count (function).

I am trying to count number of sales for each company.

I am counting every bill that I have sent a company.

I use the expression = Count(distinct [BKPF.Document Number_BELNR])

which is supposed to count every bill and link to one company.

I know that the number of bills that I have sent to companies is total 18.852 (see attachment).

But I want to show the split between companies but I get 18.852 for every company which does not make sense.

regards, Darri Hilmarsson

[tresesco]

Could you post your sample app that shows the issue?

[Anonymous]

What do you mean by sample app?

[Anonymous]

Are bill numbers and copany number available in same table or you have multiple tables.

Have you mapped those tables with common fields????????

Sample app means, please provide a qvw file with sample data so that we can understand you issue more easily.

Regards

Nitin

[tresesco]

Please refer :

Preparing examples for Upload - Reduction and Data Scrambling

[swuehl]

Are your tables correctly linked to each other, so QV find its path from dcoument number to company?

Could you post your table view?

[#7 · Accepted solution]

Could be an issue with table associations/links. As mentioned before it would help seeing an example qvw, or at least a screenshot of the full data model (Ctrl+T).

[Anonymous]

Here is the table view.

[Anonymous]

I have found what the problem is.

It is problem with how I link the tables together.

I can't  get the information I want with how I link the tables together.

I am gonna change how I link the tables.

Thanks a lot for the help