Discussion board where members can get started with Qlik Sense.
In my load statement I wanna add a flag on Invoice level if the its the first invoice (based on invoicedate) in every Order.
Any help would be much appreciated.
Is it possible to do something like:
if (min(InvoiceDate) ?, 1, 0) as InitialInvoice
Go to Solution.
As far as I get it, the following code will help you:
,min(InvoiceDate) as InvoiceDate
,'1' as Flg
Group by OrderId;
Where the minimum date is occurs by OrderId, the Flg columns contains 1 else null or missing value.
Thanks for the help undergrinder. Works perfect!