Discussion board where members can get started with Qlik Sense.
I have a table, which a want to tranform based on the first occurence of the OrderN (see below):
Where status='order-created' // status exists in the main table, so i filter out certain records by this field value
order by [ДатаIx] asc
WHERE NOT EXISTS (OrderN);
DROP FIELD [ДатаIx] FROM OrderTMP;
The result is that both orders 555 exist.
Where is the error?
Go to Solution.
May be try this
order by [ДатаIx] asc;
Right Join (OrderTMP)
Min(ДатаIx) as ДатаIx
Group By OrderN;
How about using FirstSortedValue,
FirstSortedValue(Channel,Date) as Channel
group by OrderN;
wow, this works either
i didn't know about this function
thanks for a clue