Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

gidon500
Contributor II

Filter data list

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

Tags (1)
1 Solution

Accepted Solutions
salto
Valued Contributor II

Re: Re: Filter data list

Code.jpg

Maybe this piece of code could do the job.

Regards.

3 Replies
gidon500
Contributor II

Re: Filter data list

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
Valued Contributor II

Re: Re: Filter data list

Code.jpg

Maybe this piece of code could do the job.

Regards.

gidon500
Contributor II

Re: Filter data list

Hi salto

thank you very much

gidon


Community Browser