Discussion Board for collaboration on QlikView Scripting.
I have a table with payments. Main key is Dossier# and - among others - I have the fields payment date and amount payed.
I need to make a copy of this table, in which all payments for one date are summarized. See example below. Can anyone help me out about how to achieve this in the load script?
Go to Solution.
If User and status are unique per Dossier# and date, you can do it like
Sum(Amount) as TotalAmount,
Only(User) as User,
Only(Status) as Status
GROUP BY [Dossier#], [Payment date];
Sum(Amount) as TotalAmount
Thanks for your swift reply, Swuehl!! How do I get back the fields from the original table, such as Status and User? Without of course, getting the orinale date duplicates back!!
Could u explain further.
OK, gonna try that and will get back to you!
Do you want the aggregated table bearing the same/different name as the original table ?
Thank you very much!! Worked like a charm!!
No, that's not very important..