topic Re: How can i show Duplicate Row in Straight table/ Table Box in QlikView

How can i show Duplicate Row in Straight table/ Table Box

sspawar88 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have straight table in which columns are DQ_TIME_ID, Exception1,Exception2, Exception3...Exception15 i.e 16 dimension

and i have also added Count(DQ_TIME_ID) in Expression. it shows Duplicate Rows at the count.

How can i show all those duplicate rows in Straight Table.?

i have a requirement to show 15 column i.e Exception1 to Exception15 in which count should match with database.

Re: How can i show Duplicate Row in Straight table/ Table Box

marcus_sommer — Mon, 02 May 2016 11:35:06 GMT

You need a unique row-identify to show duplicates directly within a straight-table or a table box. You could create them within the script per: rowno() or recno().

- Marcus

Re: How can i show Duplicate Row in Straight table/ Table Box

sunny_talwar — Mon, 02 May 2016 11:37:45 GMT

May be change your expression to this:

If(Count(DQ_TIME_ID) > 1, Count(DQ_TIME_ID))

Now all the rows that are left are those which are duplicate rows.

Re: How can i show Duplicate Row in Straight table/ Table Box

avinashelite — Mon, 02 May 2016 11:39:51 GMT

if all the columns combination have the same value in Qlikview then the duplicate values won't appear in Qlikview just like the List box ..in order to show such data ..use RECNO() or ROWNO() function in the script and then add the same in front end ...this will help you to show the duplicate values

Re: How can i show Duplicate Row in Straight table/ Table Box

iancloves — Thu, 30 Aug 2018 15:47:59 GMT

I am having a similar issue. My list show 4 rows but the count of rows shows 5. recno() function shows a dash for some reason. 1 of the rows is duplicated.

Can someone help me to show all 5 rows?

Re: How can i show Duplicate Row in Straight table/ Table Box

marcus_sommer — Fri, 31 Aug 2018 05:34:23 GMT

You need to add recno() or rowno() within the load to be able to display them as dimension within the table. Beside this you are not really counting else your are adding the field. If any fieldvalue is grater than 1 your expression result will be greater as the number of records.

Further should your field be a key-field you need a special attention to the results of an aggregation.

- Marcus