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

last 12 months data

i have two column monthname and consumption value

monthname has the value between aug2010 to jul2012 and also have consumption repectively

now tell me how to calculate consumtion value for the last 12 months

1 Reply
Not applicable
Author

Try like:

=sum(if(monthname>=Date( (MonthStart(Today())-365),'MMMYYYY'),consumption))

Regards

R