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-01 | 1 |
2013-02-01 | 1 |
2013-03-01 | 1 |
2013-04-01 | 1 |
2013-05-01 | 1 |
2013-06-01 | 1 |
2013-07-01 | 1 |
2013-08-01 | 1 |
2013-09-01 | 1 |
2013-10-01 | 1 |
2013-11-01 | 1 |
2013-12-01 | 1 |
2014-01-01 | 1 |
2014-02-01 | 1 |
2014-03-01 | 1 |
2014-04-01 | 1 |
... | 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-03 | 3 | sum from 2013-01-01 to 2013-03-01 |
2014-03 | 15 | sum 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