topic Re: filter for distinct field in QlikView

filter for distinct field

Tue, 16 Apr 2013 15:44:44 GMT

Hi,

I have a table A where each record has a unique ID.

I have created a table B from table A by concatenating various conditions.

I have now realised some records appear 2 or more times in table B as they belong to 2 or more conditions. How can I filter to only show each unique ID once?

I realised i can do count (distinct unique ID) in a chart, however this adds an additional column which i dont want.

Does anyone know of a solution to this problem?

Thanks,

Re: filter for distinct field

nilesh_gangurde — Tue, 16 Apr 2013 16:07:41 GMT

hii,

use "Distinct" at the time of load. then your scrip of loading table B is as follows:

load distinct * from table B;

-Nilesh

Re: filter for distinct field

Tue, 16 Apr 2013 16:21:31 GMT

hi,

table A contains distinct unique IDs.

what I am doing at the moment is:

tableB:

load

resident tableA

where condition1;

concatenate load

resident tableA

where condition 2;

hence your method nilesh doesnt accomplish the desired result.

thanks for your help though. hopefully my clarification helps.

Re: filter for distinct field

Tue, 16 Apr 2013 16:21:40 GMT

hi,

table A contains distinct unique IDs.

what I am doing at the moment is:

tableB:

load

resident tableA

where condition1;

concatenate load

resident tableA

where condition 2;

hence your method nilesh doesnt accomplish the desired result.

thanks for your help though. hopefully my clarification helps.

Re: filter for distinct field

nilesh_gangurde — Tue, 16 Apr 2013 16:38:55 GMT

if you are concatenating the two tables its difficult to have distinct values...

instead of that you can join the two tables on the field "1"....

-Nilesh

Re: filter for distinct field

Tue, 16 Apr 2013 16:49:59 GMT

Hi ,

Try this code below

tableB:

load

resident tableA

where condition1;

concatenate

Load *

where not Exists(1); //Field1 Name

load

resident tableA

where condition 2;

Regards

//Yusuf