Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

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.

View solution in original post

7 Replies
Highlighted
MVP
MVP

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.

View solution in original post

Highlighted
Not applicable

Thanks! that worked.

Highlighted
Not applicable

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.

Highlighted
Not applicable

Hi poojamondal

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

I am facing the same issue.

Highlighted
Not applicable

Varun Raj,

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

Thanks,

Singh

Highlighted
Not applicable

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

Highlighted
Not applicable

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