Qlik Sense Concat Expression in Object Table

[Jeff_Brown]

Hi All,

I'm trying to do a very simple Concat expression in a table and just cant get it to work...keep getting 'invalid dimension'.

Data;

Shipment No	Order No
123456	111111
123456	222222
123456	333333
123456	444444

Expression;

=Concat([Order No],',') as [Order No's]

Desired Output;

Shipment No	Order No's
123456	111111,222222,333333,444444

Can anyone please guide me what I am doing wrong?

Thank you.

[anthonyj · Accepted solution]

Hi @Jeff_Brown ,

It looks like you're doing this in the load script. If you want to achieve a concatenation of values for each Shipment Number then you'll need an aggregation once you've loaded your data.

For example:

ConcatTable:

load

[Shipment No],

Concat([Order No],',') as [Order No's]

Resident YourData

Group by [Shipment No]:

This will create another table that you can either join into your original table or leave associated through the shipment number.

If you're only doing this in the UI table object then you only need to add [Shipment No] as a dimension and Concat([Order No],',') as the measure.

I hope this helps.

Regards

Anthony

[SunilChauhan]

where ever you get 'INValid Expesssion' either in qlik view or qliksense, its indicate you have not Applied "Group By" in Script; or if applied then you Missed Some field in That Group By.

Test:

load

[Shipment No],

[Order No]

From Path;
//path from where you loading Data

TableName:

load

[Shipment No],

Concat([Order No],',') as [Order No's]

Resident Test

Group by [Shipment No];

drop table Test;

[Jeff_Brown]

Thank you Anthony, it was the aggregation once I've loaded the data that was missing.

its now working, much appreciated.