Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

consecutive months addition

Hi ,

I have only year and month fields. and on selection of year and month, it should give me the addition of months since January.

For ex, on selecting 2014 March, i want sum of January2014 + february 2014 and march 2014 value.

Thanks

4 Replies
anbu1984
Master III
Master III

Do you mean sum of days or count of months from Jan to Mar?

Not applicable
Author

Use rangesum() function may be u vl get correct output

Not applicable
Author

Hi ,

I have only year and month fields. and on selection of year and month, it should give me the addition of months since January.

For ex, on selecting 2014 March, i want sum of January2014 + february 2014 and march 2014 value.

cons month.JPG.jpg

Thanks

anbu1984
Master III
Master III

Check this