Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Show Distinct String values in Straight table ?

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.

2013-02-05_123313.png

5 Replies
chematos
Valued Contributor II

Re: Show Distinct String values

Have you tried this in an object text?

=concat(distinct Name, ',')

Regards

Not applicable

Re: Show Distinct String values

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.

chematos
Valued Contributor II

Re: Show Distinct String values

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

Not applicable

Re: Show Distinct String values

Ok, I will give those functions a try. Thanks

Not applicable

Re: Show Distinct String values

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.

Community Browser