topic Re: Show Distinct String values in QlikView

Show Distinct String values in Straight table ?

Tue, 05 Feb 2013 17:34:30 GMT

I have string based column field with many duplicate values. I wish to show only the Distinct or unique values. sounds simple or is it?

I tried Concat(DISTINCT Name) aslo Only() none have worked. Please help.

The reason why I need to use a Straight table is the need to show dates side by side.

Thank you all.

Re: Show Distinct String values

chematos — Tue, 05 Feb 2013 17:47:58 GMT

Have you tried this in an object text?

=concat(distinct Name, ',')

Regards

Re: Show Distinct String values

Tue, 05 Feb 2013 17:57:06 GMT

Correct it works in a Text object.

But wont in a Table expression. I was trying to show the tasks one row at a time vs comma sepreated, but maybe thats the only way. The =concat(distinct Name, ',') will display but doenst remove the duplicates when used in a straight table expression.

Re: Show Distinct String values

chematos — Tue, 05 Feb 2013 18:02:55 GMT

Maybe using a pivot table...

The problem is the opening of that field, to get one row you need to have an opening of 1 result for each dimension...

I would try with Firstsortedvalue() or using an aggr() function with the dimension as the group of the aggregation

Re: Show Distinct String values

Tue, 05 Feb 2013 18:08:50 GMT

Ok, I will give those functions a try. Thanks

Re: Show Distinct String values

Tue, 05 Feb 2013 18:18:57 GMT

The reason I forgot to mention for having a table is dates are associated with the Name.

QV doesn't seem to have many string functions that handle Tables well.