topic How to count duplicated data without using distinct in QlikView

How to count duplicated data without using distinct

Anonymous — Mon, 26 Jan 2026 16:26:21 GMT

Hi, Qlikview community

I have one problem that I need help to solve.

I want to count the amount of differenct Document Numbers. It should be pretty easy but that is a twist.

The Document Number can have the same for difference Company Code.

So I have one document number 52001186 for company code 1100 and the same document number for company code 1000.

Which means that I can't use DISTINCT.

When I use DISTINCT I get total of one document number.

I want the answer to be 2 because this is two company codes.

Any ideas?

Vendor Name	Company Code	Document Number
-	1100	52001186
-	1100	52001186
-	1100	52001186
-	1100	52001186
IKEA	1100	52001186
-	1000	52001186
-	1000	52001186
-	1000	52001186
Nestle	1000	52001186

regards Darri

Re: How to count duplicated data without using distinct

Colin-Albert — Fri, 05 Jun 2015 15:53:07 GMT

Concatenate the Company Code & Document Number, and then calculate the distinct count.

Re: How to count duplicated data without using distinct

sunny_talwar — Fri, 05 Jun 2015 16:29:37 GMT

In terms of expression, this is what Colin Albert‌ means (if I am not wrong):

=Count(DISTINCT [Document Number] & [Company Code])

Checkout the text box object in the attached qvw.

Best,

Sunny

Re: How to count duplicated data without using distinct

varunreddy — Fri, 05 Jun 2015 16:48:08 GMT

Hi Darri,

Try this. This might help:

aggr(count(DISTINCT [Document Number]),[Company Code])

Output:

Company Code	DN	aggr(count(DISTINCT DN),[Company Code])
		1
1000	52001186	1
1100	52001186	1

Re: How to count duplicated data without using distinct

MarcoWedel — Fri, 05 Jun 2015 20:54:21 GMT

‌in case the numbers are not fixed length you could add a seperator to avoid collisions:

=Count(DISTINCT [Document Number] &'/'& [Company Code])

Hope this helps also.

regards

Marco

Re: How to count duplicated data without using distinct

lylererger — Fri, 05 Jun 2015 21:09:47 GMT

The code below - removing dublicates.

[tmpObjects]:

LOAD

Where Flag=0;

LOAD

if(Previous(ICS_Field)=ICS_Field,1,0) as Flag;

LOAD

Resident Objects;

DROP Table Objects;

DROP Field Flag From tmpObjects;