Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

How to aggregate the results of table in load script

Hi I am creating a table by concatenating records, and the result is not coming the way I would like for it to. The data from my fields are not associating properly, even though they are all associated to the key field ("Submission ID").

You see I have the same Submission ID 10-times. It is ideal for me to be able to aggregate the data in this straight table so that I do not have so many null (---) values.

Is there a way to do this in the load script? I tried a combination of using Concat (Fields) and Subfield, but this does not work properly when a Submission has 2 or more products.

Any help would be appreciated. Thank you.