2 Replies Latest reply: Mar 11, 2013 2:44 AM by Sushil Kumar RSS

    How to convert excel formula into Qlikview expressions?

      Guys,

       

      Please help me on solving and having the exact report below:

       

      Say that these my data

       

      ITEM INQUIRY

      MONTH YEARQTY
      DEC-201156
      JAN-201260
      FEB-201230

       

      BACKDATE QTY

      MONTH YEARQTY
      DEC-20116
      JAN-20129
      FEB-201215

       

       

      THIS THE FORMAT/FORMULA EACH MONTH:


      JAN-2012FEB-2012MAR-2012
      BEGINNINGDec 2011 item inquiry + Dec 2011 back dateJan 2012 item inquiry + Jan 2012 back dateFeb 2012  item inquiry + Feb 2012 back date

       

      RESULT:


      JAN-2012FEB-2012MAR-2012
      BEGINNING626945

       

       

      I really don't know how to do that in set analysis or what should be the good thing to do.

       

      Your help and suggestions are much appreciated.

       

      Thanks,

      Bill