topic Filter Data at load time in QlikView

Filter Data at load time

Sat, 15 Feb 2014 22:44:25 GMT

Hi all

I am loading a list of people from a field named receiver

How can I restrict the list of names in my script so that only certain records return?

I need to only return records where receiver name is heidic, chrisg or matthewcat

Can you help please?

thankyou in advance.

Re: Filter Data at load time

hic — Sat, 15 Feb 2014 22:57:44 GMT

Load ... From ... Where Match(receiver,'heidic','chrisg','matthewcat');

HIC

Re: Filter Data at load time

maxgro — Sat, 15 Feb 2014 23:10:16 GMT

and also like

and also =

TabFilter:

load *

where receiver like 'heidic' or receiver = 'chrisg'

;

LOAD * INLINE [

receiver

heidic

chrisg,

matthewcat

];

with your script

LOAD

.......

FROM [..\PURCHASE_RECEIPT_NEW.qvd] (qvd)

where

RECEIVER like 'heidic' or RECEIVER like 'chrisg' or RECEIVER like 'matthewcat';

Re: Filter Data at load time

Sat, 15 Feb 2014 23:16:28 GMT

Hi Henric

I am just not getting the result I need due to my lack of knowledge. I have tried without success. I have pasted my script below; can you please type in the required script where it should go? If I can see this, I may have a chance in future of better understanding.

ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='D/MM/YYYY';
SET TimestampFormat='D/MM/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Directory;

LOAD ORDER_NO,
     LINE_NO,
     RELEASE_NO,
     RECEIPT_NO,
     CONTRACT,
     PART_NO,
     DESCRIPTION,
     VENDOR_NO,
     RECEIPT_REFERENCE,
     NOTE_TEXT,
     QTY_ARRIVED,
     QTY_INSPECTED,
     QTY_TO_INSPECT,
     ARRIVAL_DATE,
     RECEIVER ,
     QTY_INVOICED,
     QC_CODE,
     NO_OF_INSPECTIONS,
     RECEIVE_CASE,
     RECEIVE_CASE_DB,
     QTY_CONSIGNMENT,
     AUTOMATIC_INVOICE,
     AUTOMATIC_INVOICE_DB,
     NOTE_ID,
     PRINTED_ARRIVAL_FLAG,
     PRINTED_ARRIVAL_FLAG_DB,
     PRINTED_RETURN_FLAG,
     PRINTED_RETURN_FLAG_DB,
     BUY_UNIT_MEAS,
     UNIT_MEAS,
     CONV_FACTOR,
     REQUISITION_NO,
     REQ_LINE,
     REQ_RELEASE,
     DEMAND_CODE,
     DEMAND_OPERATION_NO,
     DEMAND_ORDER_CODE,
     DEMAND_ORDER_NO,
     DEMAND_ORDER_TYPE,
     DEMAND_RELEASE,
     DEMAND_SEQUENCE_NO,
     MANUFACTURER_ID,
     PART_OWNERSHIP,
     PART_OWNERSHIP_DB,
     OWNING_CUSTOMER_NO,
     PROJECT_ID,
     ACTIVITY_SEQ,
     APPROVED_DATE,
     FINALLY_INVOICED_DATE,
     INV_QTY_ARRIVED,
     NOTIFIED_CONSUMED_QTY,
     AIRWAY_BILL_NO,
     OBJID,
     OBJVERSION,
     OBJSTATE,
     OBJEVENTS,
     STATE,
     OBJKEY

FROM

[..\PURCHASE_RECEIPT_NEW.qvd]
(qvd)

Re: Filter Data at load time

hic — Sat, 15 Feb 2014 23:25:32 GMT

The "where match ..." Should be written right at the end of the load statement, right after "(qvd)". Note that everything i case sensitive, hence

... (Qvd) where Match(RECEIVER, 'heidic', ... )

hic

Re: Filter Data at load time

Sat, 15 Feb 2014 23:40:32 GMT

Thankyou very much!!!! Appreciate you taking the time on a novice like me.

cheers