Discussion Board for collaboration on QlikView Scripting.
I have a straight table as :
I want the output as :
I would look at sorting that in the load script, probably using the Previous() and maybe Order By, depending on your raw input data.
Best Regards, Bill
As far as Raw data is concerned , i have 2 tables ..
First Table looks like :
Is the attached qvw the sort of thing you were after ?