14 Replies Latest reply: Sep 23, 2014 5:37 AM by Nayan Lalla RSS

    Condition in back ground scripting

    Nayan Lalla


      Hi.  Below is an extract of my scripting.

      Its basically bringing  Sales quantity, Sales Value, Cost of Sales per Item per per Customer per Month.

       

      LOAD

       

      [Sales Qty],
      [INCOME],
      [COS],

      [Financial Year],
      [Calendar Month],
      [Item Code],
      [Customer Code]

       

      FROM

      [\\ELL-QVW-001\Qlikview\Qlikview Models\QVD\Pol - ELLDAT\Transactions.qvd]
      (
      qvd)

       

      In our data source, there were certain values which was incorrectly process and therefore i want to correct this in the scripting.

       

      For eg, say,  Item Code, ABC,  in Calendar month, Jan 2014 , Customer , 'John Smith',  the Cost of Sales (COS) was incorrectly processed by an extra $40 000.  How do i create a script that decrease the Cost of Sales by $40 000 for this item for that month.

       

      Is this correct?   If ([item Code]='ABC' and Calendar Month='Jan 2014' and Customer Code='John Smith', [COS]= -40000)

       

      or do i use a 'where statement' at the end?

       

      Thanks

      kind regards

      Nayan

       


      ,