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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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

Labels (1)
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