topic Re: How to display Duplicate records !!!!! in QlikView

How to display Duplicate records !!!!!

Fri, 30 May 2014 13:15:24 GMT

Hi All

Can any one help me how to display duplicate records in front end.

tab1:

Id name

1 robert

2 john

innerjoin

tab2:

id lastname

1 jack

2 dev

1 ford

1 das

output is: id Name Last Name

1 robert jack

1 robert ford

1 robert das

now i need to see those 3 ones in front end please help me....

Re: How to display Duplicate records !!!!!

its_anandrjs — Fri, 30 May 2014 13:20:29 GMT

You are using right inner join see the load script

tab1:

LOAD * Inline

[Id, name

1, robert

2, john

];

inner join

tab2:

load * Inline

[Id, lastname

1, jack

2, dev

1, ford

1, das

];

And on table box plot values

Id, name, lastname

And why you want to display only those 3 values.

Re: How to display Duplicate records !!!!!

alexandros17 — Fri, 30 May 2014 13:23:33 GMT

tab1:

LOAD * Inline [

Id, name

1 , robert

2 , john

];

inner join

tab2:

LOAD * Inline [

id, lastname

1 , jack

2 , dev

1 , ford

1 , das

];

You can show data with a table or a chart (in this case add as expression the value 1)

Re: How to display Duplicate records !!!!!

Fri, 30 May 2014 13:35:42 GMT

Hi Alessandro

I Think There is no concept of right inner join in qlikview...

Re: How to display Duplicate records !!!!!

Fri, 30 May 2014 13:37:11 GMT

Add a expression field in a straight table - =RowNo()

Re: How to display Duplicate records !!!!!

maxgro — Fri, 30 May 2014 13:53:31 GMT

create a straight table chart with

dim

Id, name, lastname

expression

if(count(TOTAL <id> name)>1, 1)

you can hide the expression in presentation tab

Re: How to display Duplicate records !!!!!

alexandros17 — Fri, 30 May 2014 13:55:20 GMT

What do you mean with right inner join??

The instruction I gave to you is a inner join so only matching records on matching fields will be taken

Re: How to display Duplicate records !!!!!

Fri, 30 May 2014 14:01:23 GMT

Thank you Massimo.

Re: How to display Duplicate records !!!!!

Fri, 30 May 2014 14:02:13 GMT

Thank you all.

Re: How to display Duplicate records !!!!!

Fri, 30 May 2014 14:08:31 GMT

why dont you just concatenate id and lastname as calculated dimension and hide it