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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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