4 Replies Latest reply: Feb 24, 2014 8:41 AM by Claudio Degli Antoni RSS

    Set Analisys condition with table field

    Claudio Degli Antoni

           Hi all,

       

           I would like use "set analisys" instead of "if" funcion.

       

       

           I would like to check another  field in same table !!!  see "{Date2}  "

         

       

           Example:

          

           Orders:

           LOAD * INLINE [
          Customer,           OrderDate,           Article,       Qty,              Date2
          000001,           20-01-2011,     FFF200,         50,      20-01-2014,
          000002,           21-02-2012,     GGG120,      300,     20-01-2013,
          000003,           22-03-2013,     HHH140,     1200,     20-01-2011,
          000004,           02-02-2014,     RRR120,     1500,     02-02-2014,
          ]

       

       

      ( {$<OrderDate =  {'>=$(vData1)<=$(vData2)'}     , OrderDate =  {Date2}                    >} [Qta])

       

        Many Thanks in advance

        Claudio