topic Re: showing duplicate rows in TableBox/Straight Table in QlikView

showing duplicate rows in TableBox/Straight Table

Anonymous — Thu, 30 Aug 2012 17:48:24 GMT

i am loading multiple excel file using *.csv

I need all duplicate Value also straight and tablebox hides duplicate Value

I Tried Rowno() but it also hides duplicate rows

Re: showing duplicate rows in TableBox/Straight Table

m_woolf — Thu, 30 Aug 2012 18:04:36 GMT

In your load script:

RowNo() as LineNo,

Then include LineNo in your table. You can shrink the column as much as possible and change font color to equal background color to make the column less obtrusive.

Re: showing duplicate rows in TableBox/Straight Table

Thu, 30 Aug 2012 19:31:29 GMT

table box always doeas it this way

try to use straight table wit the expression =FieldIndex('MYear',MYear)

mwolf idea seems to be still the best

Re: showing duplicate rows in TableBox/Straight Table

whiteline — Thu, 30 Aug 2012 19:38:13 GMT

I think =FieldIndex('MYear',MYear) will be the same for duplicates.

Try Count(MYear) in a straight table (MYear as a dimension).

Or even Count({1<MYear={"=Count(MYear)>1"}>}MYear)

This will show only duplicated MYear-s in a straight table.

Or use =aggr(Only({1<MYear={"=Count(MYear)>1"}>}MYear), MYear) as a list box expression.

You'll see only duplicates.

Re: showing duplicate rows in TableBox/Straight Table

Tue, 10 Sep 2013 00:42:13 GMT

I did the same thing by changing background color of the columb and reduced its zise 60% (not able to do much more than that)....lol

Re: showing duplicate rows in TableBox/Straight Table

rajeshvaswani77 — Tue, 10 Sep 2013 06:24:43 GMT

Use straight table and show the row number, you must see all the rows. Then go to presentation and hide the column.

thanks,

Rajesh Vaswani