Qlik sense: How to aggregate strings into single row in script

Question

I am trying to aggregate strings that belong to the same product code in one row. Which Qlik sense aggregation function should I use?

image

I am able to aggregate integers in such example, but failed for string aggregation.

Answer 1

As x3ja mentioned, you can use an aggregation function in charts that will work for strings, including:

• MaxString()
• Only()
• Concat()

These can result in the type of thing you're looking for:

It's worth noting, though, that this sort of problem is almost always an issue with the underlying data model. Depending on what your source data looks like, you should consider investigating your use of Join and/or Concatenate. You can see more info on how to use those functions on this Qlik Help page.

Here's a very basic example of using a Join to properly combine the data in a way that results in all data showing up a single record without needing any aggregations in the table chart:

Answer 2

Have you tried maxstring() - this is a string aggregation function.