Discussion board where members can learn more about Qlik Sense App Development and Usage.
can anybody help me with the below scenario using Qlik Load Script.
I have table with the below structure
now I have created a resident table using qlik LOAD with the below structure (i.e. de-normalizing the above one )
Resident Table :
Now I want to create a sequence for each ticket.... output should come like this
If I have the same Data in SQL then I can use the below query to the sequence
select ROW_NUMBER() OVER (partition by ticket_no order by date asc)
Go to Solution.
LOAD DISTINCT Ticket_no,
createdate as Date,
'Created' as status
(html, codepage is 1252, embedded labels, table is @1);
changeDate as Date,
If(Ticket_no = Peek('Ticket_no'), RangeSum(Peek('sequence'), 1), 1) as sequence
Order By Ticket_no, Date;
DROP Table Table;
Thanks sunny I have tired the below one but didn't wokredout... and ur solution works perfect
If(Ticket_no= Peek('Ticket_no'), 1 + Peek('Sequence'), 1) as Sequence