topic Re: concat and Aggr in QlikView

concat and Aggr

venkatg6759 — Wed, 12 Feb 2014 20:13:17 GMT

I have a straight table like this

ID Provider Name Primary Name

11 Chase Bryan David

11 Chase Amelia David

I need to get table like this

ID Provider Name Primary Name

11 Chase Bryan;Amelia David

Help me how to write the expression .I need to concat Name

Thanks,

Venkata

Re: concat and Aggr

Nicole-Smith — Wed, 12 Feb 2014 20:14:39 GMT

concat(distinct Name, ';')

Re: concat and Aggr

Wed, 12 Feb 2014 20:21:35 GMT

Please create the straight table like below:

Dimension: ID

Expressions: Concat(Distinct Provider , ';') Concat(Distinct Name, ';') Concat(Distinct [Provider Name] , ';')

You can't use concat inside aggr function for calculated dimensions.

Re: concat and Aggr

stevedark — Wed, 12 Feb 2014 20:24:58 GMT

Why would you not have ID, Provider and Primary Name as dimensions and simply the Concat of the Name as an Expression?

I suppose, it depends on what should happen if there were multiple Providers and Primary Names within the same ID. Would that be Chase; Other or two separate lines?

Re: concat and Aggr

venkatg6759 — Wed, 12 Feb 2014 20:29:13 GMT

Thanks Steve . I tried using ID, Provider and Primary Name in dimension and kept Name in the expression. It worked.