Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

lixingkai
New Contributor III

How to sum value to the same month by years?

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

Community Browser