topic Re: How to remove duplicate values row in qlikview in QlikView

How to remove duplicate values row in qlikview

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

Hi,Experts

My extracted data having duplicate values in a row.My data is below manner

Header 1	Header 2	Header 3	Header 4	Header 5
ID	NAME	MARKS	SCORE	PINCODE
1	RAM	34	2	3453
2	LRENU	44	7	909323
2	LRENU	44	8	909323
4	JOHN	54	6	3847
4	JOHN	54	4	3847
6	HUE	84	5	9303

Here I want to remove duplicate rows & getting my output with based on max score.

The output is below manner

ID NAME MARKS SCORE PINCODE

1 RAM 34 2 3453

2 LRENU 44 8 909323

4 JOHN 54 6 3847

6 HUE 84 5 9303

Thanks in Advance.

Re: How to remove duplicate values row in qlikview

Chanty4u — Thu, 28 Jun 2018 10:20:54 GMT

try this

Data:

LOAD A,

FROM

tabl1;

Inner Join(Data)

LOAD

max(Score) as NewScore

Resident Data

Group by Name;

Re: How to remove duplicate values row in qlikview

Anonymous — Thu, 28 Jun 2018 10:53:05 GMT

At the time of reload the edit script show the output same as the excel sheet.But my output was above manner.

Thanks Chanty.

Re: How to remove duplicate values row in qlikview

yenumulagopi — Thu, 28 Jun 2018 11:01:33 GMT

Hi Suman,

Using Straight table we can do this.

Take the dimensions as ID, Name, Marks and PINCODE.

In the Expression : Sum(SCORE)

If you do this you will get the desire output

You can refer the attachment for better understanding.@

Thanks,

Gopi

Re: How to remove duplicate values row in qlikview

yenumulagopi — Thu, 28 Jun 2018 11:06:57 GMT

Hi Suman,

use Max(SCORE).

Thanks

Re: How to remove duplicate values row in qlikview

Anonymous — Thu, 28 Jun 2018 11:07:53 GMT

Hi Gopi krishna

Its good,the 2nd row get the max score value(i,e.8).In my output the score value of 2nd row is 7.

Thanks.

Re: How to remove duplicate values row in qlikview

yenumulagopi — Thu, 28 Jun 2018 11:15:04 GMT

Hi Suman,

You can check my 2nd post. It is matching with your correct output manner.

Thanks

Re: How to remove duplicate values row in qlikview

Anonymous — Thu, 28 Jun 2018 11:21:45 GMT

You give me good suggestion.Its working.

Thanks Gopi krishna.

Re: How to remove duplicate values row in qlikview

yenumulagopi — Thu, 28 Jun 2018 11:37:44 GMT

You Welcome.

Don't forgot to make it as correct answer.

Thanks