topic Re: Hide dublicate rows in QlikView

Hide dublicate rows

Fri, 27 Sep 2013 12:39:52 GMT

Hi,

I have a pivot table with several dimensions. One dimension is ISBN number and one dimension is author name. On the row with author name it displays several authors if one book has several authors. On the expressions row it calculates how many times each ISBN number has been read. In the case of two authors it displayes that it has been read two times (on time per author) eventhough it should only display that it has been read one time since it´s the same ISBN number. If the ISBN number has been read 2 times it shows 4 times (2 per author) and so on. Does any one know how to hide this duplicate row? I.e. how to only show the first author in this case?

Thanks!

/Sofie

Re: Hide dublicate rows

srchilukoori — Fri, 27 Sep 2013 12:43:21 GMT

can you upload an example app.

Re: Hide dublicate rows

struniger — Fri, 27 Sep 2013 12:53:19 GMT

You could try to concat the authors - example in the attachment

Re: Hide dublicate rows

Anonymous — Fri, 27 Sep 2013 12:55:41 GMT

Sofie,

I recommend not to use Author names as dimension. Use only one dimension, ISBN, and authors can be in expression like this

concat (distinct "Author Name", '; ')

Apparently there is no need for pivot table in this case, you can use straight.

Regards,

Michael

Re: Hide dublicate rows

Tue, 01 Oct 2013 18:03:47 GMT

Thank you very much. You all been very helpful. The issue was resolved by the Concat expression

Regards

Sofie

Re: Hide dublicate rows

Tyler_Waterfall — Sat, 18 Jun 2016 13:42:21 GMT

sofie.zettergren‌ - found your post here and am curious how you were cataloging books. I'm interested in cataloguing our library but would love to find a source for ISBN and book information (instead of manually entering the info).

Thanks!