Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
chandni90
Contributor

Script code

Hi

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!

as.png

1 Solution

Accepted Solutions
MVP
MVP

Re: Script code

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);

View solution in original post

5 Replies
jonas_rezende
Valued Contributor

Re: Script code

Hi, Chandni Bhowmick.

Try:

LOAD

document,

creditor,

status

from [<nametable>]

where

status = 'Cleared Item'

Hope this helps!

chandni90
Contributor

Re: Script code

Hi

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

pokassov
Valued Contributor

Re: Script code

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);

MVP
MVP

Re: Script code

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);

View solution in original post

pratap6699
Contributor

Re: Script code

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