topic Re: Load Specific Value Only in QlikView

Load Specific Value Only

Mon, 03 Nov 2014 18:53:45 GMT

Brand new to Qlikview scripting, hope someone can help. I want to only load lines with a specific value identified in them. I've tried several different statements and I can't get them to work. Here is the script:

LOAD:
     SAP_CUST_NO,
     DIST_CHANNEL as SHIPMENT_DIST_CHANNEL,
     ORD_STATUS,
     SAP_ITEM_NO as SHIPMENTS_SAP_ITEM_NO,
     ACT_SHIP_DATE as DAY_CODE,
     SHIP_QTY_SELL

FROM

(qvd);

I only want to load lines with the ORD_STATUS of S, how do I do this?

Re: Load Specific Value Only

Anonymous — Mon, 03 Nov 2014 18:55:37 GMT

Hi,

you can do this using a where clause:

LOAD:
     SAP_CUST_NO,
     DIST_CHANNEL as SHIPMENT_DIST_CHANNEL,
     ORD_STATUS,
     SAP_ITEM_NO as SHIPMENTS_SAP_ITEM_NO,
     ACT_SHIP_DATE as DAY_CODE,
     SHIP_QTY_SELL

FROM

(qvd) where match( ORD_STATUS, 'S');

Best regards

Stefan

Re: Load Specific Value Only

Anonymous — Mon, 03 Nov 2014 18:56:16 GMT

LOAD:
    SAP_CUST_NO,
    DIST_CHANNEL as SHIPMENT_DIST_CHANNEL,
    ORD_STATUS,
    SAP_ITEM_NO as SHIPMENTS_SAP_ITEM_NO,
    ACT_SHIP_DATE as DAY_CODE,
    SHIP_QTY_SELL

FROM

(qvd)

WHERE ORD_STATUS = 'S'

;

Re: Load Specific Value Only

its_anandrjs — Mon, 03 Nov 2014 18:56:20 GMT

Try to load like

LOAD:
    SAP_CUST_NO,
    DIST_CHANNEL as SHIPMENT_DIST_CHANNEL,
    ORD_STATUS,
    SAP_ITEM_NO as SHIPMENTS_SAP_ITEM_NO,
    ACT_SHIP_DATE as DAY_CODE,
    SHIP_QTY_SELL
FROM
(qvd)

Where ORD_STATUS = 'S';

Here is assume ORD_STATUS has the values 'S' then use this Where ORD_STATUS = 'S'; at the end of the load script and you can use Match(ORD_STATUS,'S') also

Regards

Anand

Re: Load Specific Value Only

Mon, 03 Nov 2014 18:59:07 GMT

Thank you!!!