Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
magnusrydberg
New Contributor II

How do I create an aggregated file in a Qlik Sqript?

I have a file containing comments on an order. This comments are created at different times and therefore in different records, many comment records on one order.

I now want to create a new file in my QV script containing one comment record per order. This new record should be a sum of all the different comments in the old file.

See attached file for further explanation

1 Reply
ahaahaaha
Honored Contributor

Re: How do I create an aggregated file in a Qlik Sqript?

Hi Magnus,

Try as

LOAD

    "Order",

    Concat("Comment")

FROM [lib://!D/How to create new  file in a qlik Sqript.xlsx] //here is the path to your file xlsx

(ooxml, embedded labels, header is 1 lines, table is Blad1)

Group By "Order";

Result

1.jpg

Regards,

Andrey