4 Replies Latest reply: Nov 3, 2014 1:59 PM by Jonathan Greene RSS

    Load Specific Value Only

      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

      [C:\Users\greenejo\Desktop\Qlikview Development Projects\Depletions Project\QVDs\VW_F_NAM_SAL_ORD.qvd](
      qvd);

       

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

       

        • Re: Load Specific Value Only
          Stefan Kunte

          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

          [C:\Users\greenejo\Desktop\Qlikview Development Projects\Depletions Project\QVDs\VW_F_NAM_SAL_ORD.qvd](
          qvd) where match( ORD_STATUS, 'S');


          Best regards

          Stefan

          • Re: Load Specific Value Only
            Bill Markham

            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

            [C:\Users\greenejo\Desktop\Qlikview Development Projects\Depletions Project\QVDs\VW_F_NAM_SAL_ORD.qvd](
            qvd)


            WHERE     ORD_STATUS = 'S'

            ;

            • Re: Load Specific Value Only
              Anand Chouhan

              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
              [C:\Users\greenejo\Desktop\Qlikview Development Projects\Depletions Project\QVDs\VW_F_NAM_SAL_ORD.qvd](
              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