Concatenating Multiple Values of a Field

[byrnel0586]

Hi,

I am wanting to concatenate multiple 'MRP D/C Dates' into one cell in order to only have 1 row per member in my pivot table. In my example there are only 2 dates, but there can be more than that. I have tried creating variables and combining those but that gives me errors in my calculated dimension. For instance, in the below example I would like to see '11/28/2016, 3/29/3016' in one row rather than it creating 2.

Any help is appreciated!

[sunny_talwar]

May be this

Aggr(Concat(DISTINCT {<MeasureID = {'MRP'} and Gap = {'>0'}>} EVENT_DATE, ','), MEM_ID)

or

=Aggr(If(Match(MeasureID, 'MRP_MRP') and Gap > 0, Concat(DISTINCT EVENT_DATE, ',')), MEM_ID)

[byrnel0586]

Thank you. I tried the second expression and got no results. In the first expression there is an error around Gap = {'>0'}.

[sunny_talwar · Accepted solution]

My bad, replace and with a comma

Aggr(Concat(DISTINCT {<MeasureID = {'MRP'}, Gap = {'>0'}>} EVENT_DATE, ','), MEM_ID)

[byrnel0586]

That worked, thank you!

[berndjaegle]

Thank you!

I am using it to generate Filter Import File for Nprinting

https://help.qlik.com/en-US/nprinting/September2018/Content/NPrinting/DeployingQVNprinting/Import-Us...