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
