1 Reply Latest reply: Aug 3, 2016 11:25 AM by Sunny Talwar RSS

    Get previous months values in qlikview scripting

    aravind jala

      I have a scenario where i have location monthname and the measure value. I need to develop the qlikview report in such a way that i should get the measure value for each location for each month.

      If there is no value associated for a month for a location i should pickup the latest measure value for the latest month prior to missing month. It need not be the previous month.

       

      Below is the example of the scenario. Can any one suggest me

       

       

      Actual ValueExpected Value
      LocationMonthValueLocationMonthValue
      AJan-15100AJan-15100
      AFeb-15200AFeb-15200
      AMay-15400AMar-15200
      AAug-15100AApr-15200
      AJan-16300AMay-15400
      AApr-16200AJun-15400
      AJun-16400AJul-15400
      AAug-15100
      ASep-15100
      AOct-15100
      ANov-15100
      ADec-15100
      AJan-16300
      AFeb-16300
      AMar-16300
      AApr-16200
      AMay-16200
      AJun-16400