2 Replies Latest reply: Oct 20, 2014 6:10 AM by Riadh Chaouch RSS

    Date

    Riadh Chaouch

      LOAD

           Status,

           Stockid,

          Model,

          RECDATE,

          INVDATE

         

      FROM

      [D:\QlikView Live\Data\NewVehicleStock.qvd]

      (qvd)  ;

       

       

       

      My Customer want to show the Available Stock till the date selected.
      with this Condition :

       

      (     STATUS <> 0  and RECDATE  <= Selected_Date    )

      or

      (     STATUS = "I"   and RECDATE <= Selected_Date     and       INVDATE > Selected_Date    )

       

       

      For example :
      if i select ( march/2014),

       

      i need to see : the stock available stock from 1900 til 31/03/2014.

      and if a car received on 20/03/2014 and invoiced  on 02/04/2014  ----->    i have to show it.

      but if a car received on 20/03/2014 and invoiced  on 28/03/2014  ----->    i dont want to show it.

       

       

       

       

       

       

       

       

      ;