topic Re: Script code in QlikView

Script code

Anonymous — Mon, 28 Sep 2015 15:07:25 GMT

I want all the document numbers that have the status 'cleared'. And I also want the document numbers that have the status only 'open' but not 'Cleared'(For example, doc no 5105600105 should only give me one record, i.e. status 'cleared' and omit the record 'open' plus all the other records having the status only 'open'). I don't know what the code should be in the script to get this. Please help.

I am not sure if I am being able to articulate what I need. Please ask me if you have any doubt. Thanks!

Re: Script code

jonas_rezende — Mon, 28 Sep 2015 15:13:54 GMT

Hi, Chandni Bhowmick.

Try:

LOAD

document,

creditor,

status

from [<nametable>]

where

status = 'Cleared Item'

Hope this helps!

Re: Script code

Anonymous — Mon, 28 Sep 2015 15:16:17 GMT

I also want the document numbers that have the status only 'opened' but not 'cleared'.

Re: Script code

pokassov — Mon, 28 Sep 2015 15:16:44 GMT

t1:

load

document,

creator,

status

from .....qvd (qvd)

where status='Cleared Item';

concatenate (t1)

load

document,

creator,

status

from .....qvd (qvd)

where status='Open Item'

and not exists (document);

Re: Script code

MK_QSL — Mon, 28 Sep 2015 15:17:27 GMT

Load

document,

creditor,

status

From FileName

Where WildMatch(status,'*Cleared*');

Concatenate

Load

document,

creditor,

status

From FileName

Where WildMatch(status,'*Open*') and not Exists(document);

Re: Script code

pratap6699 — Mon, 28 Sep 2015 17:01:31 GMT

Load document,creditor,status from source where status=cleareditem;