topic Re: same id different name in QlikView

same id different name

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table data like below

ID,Name,

100,ABC

200,DEF

100,XYZ

212,FGH

200,DDD

300,MHN

I want to show the following with result in a straight table..same id but different name

output

100,ABC

100,XYZ

200,DEF

200,DDD

how can i get this

Re: same id different name

Chanty4u — Thu, 04 Aug 2016 10:07:36 GMT

try

Dim: ID

EXP:=sum({<Id=p($(=Id={'100,'200'}))>}Id)

Re: same id different name

gauthamchilled — Thu, 04 Aug 2016 10:11:46 GMT

there are many ids that may be duplicated, so am not sure about that. then how can i use in set analysis???

Re: same id different name

Thu, 04 Aug 2016 10:14:19 GMT

You can use If(Aggr(Count(ID),ID)>1,ID)..

Thanks,

Nandu.

Re: same id different name

PrashantSangle — Thu, 04 Aug 2016 10:18:53 GMT

Hi,

In Script try like

Temp:

LOAD * INLINE [

ID,Name,

100,ABC

200,DEF

100,XYZ

212,FGH

200,DDD

300,MHN

];

NoConcatenate

T1:

Load count(Name) as cName,ID

Resident Temp

group by ID;

Final:

Load ID

Resident T1

where cName=2;

Left Join

Load * Resident Temp;

Drop Table T1,Temp;

Regards,

Re: same id different name

rajuamet — Thu, 04 Aug 2016 10:20:26 GMT

Hi Gautham Prasad,

You can use calculated dimension.

If(Aggr(Count(ID),ID)>1,ID)

PFA.

Re: same id different name

miguelbraga — Thu, 04 Aug 2016 10:27:53 GMT

Hey there,

See my attached file

I think this is what you want!

Regards,

Re: same id different name

sunny_talwar — Thu, 04 Aug 2016 10:45:31 GMT

Another way:

Dimension:

ID,

Name

Expression:

If(Count(DISTINCT TOTAL <ID> Name) > 1, 1)

and then you can safely hide the expression