Discussion Board for collaboration on QlikView Scripting.
enclosed if file
ORD is order no number .
key line no
I have a list of orders , the orders status change one a while
i need to create for every order = ORD
the first key for ORDTATUS = '-1' this is the creation of the order
and the last key for ORDTATUS = '-4' this us the close of the order
there are many orders without close line .
Go to Solution.
Maybe this piece of code could do the job.
hi to clarify
the output should be for every order
max 2 line
the creation line
and the close line if order closed
thank you very much