Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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