0 Replies Latest reply: Jun 22, 2017 10:05 PM by Larry LI RSS

    How to sum value to the same month by years?

    Larry LI

      Hello, Everyone.

       

      Currently, I get a question in app development of Qlik Sense.

      Please read the example below.

       

      I get source data as below (actually there are many record in each month)

      Date ( YYYY-MM-DD )Value
      2013-01-011
      2013-02-011
      2013-03-011
      2013-04-011
      2013-05-011
      2013-06-011
      2013-07-011
      2013-08-011
      2013-09-011
      2013-10-011
      2013-11-011
      2013-12-011
      2014-01-011
      2014-02-011
      2014-03-011
      2014-04-011
      ...1

       

      What I want to do is to get the sum from beginning to the same month in different years as below.

      Dimension ( YYYY-MM )Measure

      Comment

      2013-033sum from 2013-01-01 to 2013-03-01
      2014-0315sum from 2013-01-01 to 2014-03-01
      ...

       

      I meet this requirement for the 1st time. So can anyone help me?

      thank you very much.

       

      Larry