topic Re: Showing duplicate rows in QlikView

Showing duplicate rows

Thu, 09 Aug 2012 09:22:38 GMT

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,

Re: Showing duplicate rows

swuehl — Thu, 09 Aug 2012 09:44:49 GMT

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.

Re: Showing duplicate rows

Fri, 10 Aug 2012 07:25:45 GMT

Thanks! that worked.

Re: Showing duplicate rows

Wed, 20 Aug 2014 11:35:58 GMT

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.

Re: Showing duplicate rows

Wed, 11 Mar 2015 11:27:03 GMT

Hi poojamondal

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

I am facing the same issue.

Re: Showing duplicate rows

Sat, 25 Apr 2015 08:43:46 GMT

Varun Raj,

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

Thanks,

Singh

Re: Showing duplicate rows

Tue, 26 May 2015 09:13:54 GMT

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

Re: Showing duplicate rows

Wed, 13 Jul 2016 21:35:24 GMT

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,