Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
chandni90
Creator
Creator

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
MK_QSL
MVP
MVP

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
Specialist
Specialist

Hi, Chandni Bhowmick.

Try:

LOAD

document,

creditor,

status

from [<nametable>]

where

status = 'Cleared Item'

Hope this helps!

chandni90
Creator
Creator
Author

Hi

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

pokassov
Specialist
Specialist

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

MK_QSL
MVP
MVP

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

pratap6699
Creator
Creator

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