7 Replies Latest reply: Jul 13, 2016 5:35 PM by tej patnaik RSS

    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

        • Re: Showing duplicate rows
          Stefan Wühl

          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

              Thanks! that worked.

              • Re: Showing duplicate rows
                tej patnaik

                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

              • 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.