4 Replies Latest reply: Nov 14, 2013 4:34 PM by marcin szuberla RSS

    How to generate monthly records based on data range?

    marcin szuberla

      Hi all!


      I am pretty new to QlikView, currently experimenting a lot with scripting.

      I am currently stuck on creating a table that would give me monthly eligibility records, based on eligibility range.


      I have:



      MemberID     StartDt          EndDt

      A1               2010-01-01     2010-03-05

      A2               2011-01-01     2011-02-25


      I need to create a table that would have:

      MemberID    Year_Month

      A1               2010-01

      A1               2010-02

      A1               2010-03

      A2               2011-01

      A2               2011-02


      Does any one know how to do this? Any help is really appreciated!