topic Re: Filter data list in QlikView

Filter data list

gidon500 — Mon, 14 Oct 2013 15:36:54 GMT

Hi All

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 .

thaks

gidon

gidon500 — Mon, 14 Oct 2013 15:38:25 GMT

hi to clarify

the output should be for every order

max 2 line

the creation line

and the close line if order closed

thanks

gidon

salto — Mon, 14 Oct 2013 16:06:06 GMT

Maybe this piece of code could do the job.

Regards.

gidon500 — Mon, 14 Oct 2013 16:33:18 GMT

Hi salto

thank you very much

gidon