combining multiple values into one field

[jas0012qlik]

Is there a way to do a listagg in Qlik Sense? Or whatever the equivalent is to listagg in pl/sql...

A similar question was asked a while back but I can't get it to work for me.

[sunny_talwar]

I think you need Concat() function

Concat function - Qlik Sense

[arvind_patil]

Hi Jana,

You can achieve this with the help of concatenate() function.  but I think no such a function in Qlikview or Qliksense.

Thanks,

Arvind

[arvind_patil]

HI Jana,

Please find attachment may be it will serve your purpose.

Thanks,

Arvind Patil

[jas0012qlik]

This is good for Qlik View, but we are using Qlik Sense. Is there something comparable?

[sunny_talwar]

Concat works in QlikView and Qlik Sense

[sunny_talwar]

Make sure to check this link

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/ChartFunctions/StringAggregationFunctio...

[jas0012qlik]

I'm sorry, I'm brand new to this....

So if i only have one field i need to see, and it needs to show in succession for as many times as it shows in the table, i just use concat([field name])?  I don't need the distinct, and i can't figure out how to set the delimeter, this will just be '/'

If i decided on a sort weight, do i just list that field in the last piece? and is this syntax accurate?

CONCAT9[field name] , [, '/' [ filed name2]])

[sunny_talwar]

Something like this

Concat(FieldName, '/', FieldName2)

For Distinct

Concat(DISTINCT FieldName, '/', FieldName2)

[jas0012qlik]

This is getting close, it’s accepting the formula. It still says it’s an invalid dimension, however. I’ll keep playing with this. Thank you.