topic Re: Having trouble with the count() function in QlikView

Having trouble with the count() function

Anonymous — Tue, 17 Dec 2013 10:29:02 GMT

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

Re: Having trouble with the count() function

tresB — Tue, 17 Dec 2013 10:32:57 GMT

Could you post your sample app that shows the issue?

Re: Having trouble with the count() function

Anonymous — Tue, 17 Dec 2013 10:40:33 GMT

What do you mean by sample app?

Re: Having trouble with the count() function

Anonymous — Tue, 17 Dec 2013 10:46:23 GMT

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

Re: Having trouble with the count() function

tresB — Tue, 17 Dec 2013 10:47:08 GMT

Please refer :

Preparing examples for Upload - Reduction and Data Scrambling

Re: Having trouble with the count() function

swuehl — Tue, 17 Dec 2013 10:47:56 GMT

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

Could you post your table view?

Re: Having trouble with the count() function

Tue, 17 Dec 2013 10:52:45 GMT

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).

Re: Re: Having trouble with the count() function

Anonymous — Tue, 17 Dec 2013 11:01:58 GMT

Here is the table view.

Re: Having trouble with the count() function

Anonymous — Tue, 17 Dec 2013 11:20:04 GMT

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