Qlik Community

Ask a Question

App Development

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

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
lixingkai
Contributor III
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

0 Replies