topic Re: Displaying only unique records in a Table Object in QlikView

Displaying only unique records in a Table Object

Thu, 26 Jul 2012 09:23:44 GMT

Hi,

Is there any syntax which only displays unique records based on a particular column? For example, I have ID numbers appearing in one of the column and I only want the unique IDs to appear in the table (i.e. no duplicates). Is there any way of doing this?

Any help would be greatly appreciated.

Thanks.

Rajiv.

Re: Displaying only unique records in a Table Object

rajni_batra — Thu, 26 Jul 2012 09:30:51 GMT

use distinct() function.

hope it help!!!!!

Re: Displaying only unique records in a Table Object

Thu, 26 Jul 2012 09:36:00 GMT

Thanks Rajni for getting back to me.

How do I go about implementing that in a Table Box?

My column name is Sales_ID

Thanks.

Re: Displaying only unique records in a Table Object

swuehl — Thu, 26 Jul 2012 09:39:14 GMT

If I understood your request correctly, you can use a calculated dimension to filter your ID field, try something like

=aggr(if(count(ID)=1,ID),ID)

You can use this as field expression in a list box or calculated dimension in a (straight or pivot) table chart.

This might be not very performant on large data, so you could also use something similar in the script, creating a new field flagging the unique ID values.

Hope this helps,

Stefan