Showing duplicate rows

[#1]

Hi,

I have the following problem:

I have a table with 3 colums named Opdracht,Relnr,Refnr.

The table is as following:

Opdracht               Relnr          Refnr

1                           1               100

1                           2               101

1                           3               102

1                           4               102

2                           5               102

2                           6               103

3                           1               100

3                           7               107

3                           8               107

Here i want to show only the Rows where a 'Opdracht' has >1 of the same 'Refnr'

The result must show the following:

Opdracht               Relnr          Refnr

1                           3               102

1                           4               102

3                           7               107

3                           8               107

How can i achieve this ?

Thanks,

SY

[swuehl · Accepted solution]

You can use this expression in a table chart with dimensions Opdracht, Relnr, Refnr:

=if (aggr(NODISTINCT count(Refnr),Opdracht,Refnr)>1,1,0)

then hide the expression in presentation tab.

[#3]

Thanks! that worked.

[#4]

hi, I have an excel file which has two identical rows. In backend,  all the rows are being fetched but when i try to displcya the rows in a pivot table in frnt end then I am not able to see that identical rows. It is taking all as one entry.

Please help on this issue.

[#5]

Hi poojamondal

Were you able to figure out a solution to your problem?

I am facing the same issue.

[#6]

Varun Raj,

You need to add Rowno() as RowNum as an extra field in your LOAD statement

Thanks,

Singh

[#7]

Hi Angad,

That is similar to what I did to solve this issue. I pulled in an extra unique value field from DB to the report.

Thanks,

Varun Raj

[#8]

I am trying to apply this similar function to a table in my qlikview file, but it is not returning just the repeated values. My data is as follows:

ID	Modified_Date	Region	Product	Sales
1	1/1/2016	Midwest	CAR	$      300.00
2	1/2/2016	South	CAR	$      300.00
2	1/11/2016	West	CAR	$      300.00
3	1/3/2016	North	VAN	$      500.00
4	1/4/2016	South	TRUCK	$      650.00
5	1/5/2016	West	TRUCK	$      650.00
6	1/6/2016	Midwest	VAN	$      500.00
7	1/7/2016	West	TRUCK	$      650.00
8	1/8/2016	North	CAR	$      300.00
9	1/9/2016	North	CAR	$        300.00
10	1/10/2016	West	TRUCK	$         650.00
11	1/11/2016	Midwest	CAR	$         300.00
12	1/12/2016	South	VAN	$         500.00
13	1/13/2016	South	TRUCK	$         650.00
14	1/14/2016	West	VAN	$         500.00
15	1/15/2016	North	TRUCK	$         650.00
16	1/16/2016	West	CAR	$         300.00
17	1/17/2016	South	VAN	$         500.00
18	1/18/2016	North	CAR	$         300.00

Any way I can get onyl the highlighted rows to show up in my table?

Thanks,

T