Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Showing duplicate rows

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Showing duplicate rows

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.

7 Replies
MVP
MVP

Re: Showing duplicate rows

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.

Not applicable

Re: Showing duplicate rows

Thanks! that worked.

Not applicable

Re: Showing duplicate rows

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.

Not applicable

Re: Showing duplicate rows

Hi poojamondal

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

I am facing the same issue.

Not applicable

Re: Showing duplicate rows

Varun Raj,

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

Thanks,

Singh

Not applicable

Re: Showing duplicate rows

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

Not applicable

Re: Showing duplicate rows

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:

   

IDModified_DateRegionProductSales
11/1/2016MidwestCAR $      300.00
21/2/2016SouthCAR $      300.00
21/11/2016WestCAR $      300.00
31/3/2016NorthVAN $      500.00
41/4/2016SouthTRUCK $      650.00
51/5/2016WestTRUCK $      650.00
61/6/2016MidwestVAN $      500.00
71/7/2016WestTRUCK $      650.00
81/8/2016NorthCAR $      300.00

9

1/9/2016NorthCAR$        300.00
101/10/2016WestTRUCK$         650.00
111/11/2016MidwestCAR$         300.00
121/12/2016SouthVAN$         500.00
131/13/2016SouthTRUCK$         650.00
141/14/2016WestVAN$         500.00
151/15/2016NorthTRUCK$         650.00
161/16/2016WestCAR$         300.00
171/17/2016SouthVAN$         500.00
181/18/2016NorthCAR$         300.00

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

Thanks,

T

Community Browser