Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
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";