Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Selected Dates Range

Hi All,

I have a date field from Jan 2014 to Sep 2017.

I need to calculate sum(consumption) from Oct 2015 to Sep 2016

then I need to calculate sum(consumption) from Oct 2016 to Sep 2017

Can you please tell me how can i achieve this.

Attached app for more reference.

Thanks,

Bharat

11 Replies
tresesco
MVP
MVP

Year, Month are taken to disregard the selection in those fields. I.e. the calculation would be only based on MonthYear field's reference (defined in the range expression). Max() is used to tell monthstart() where it should start from to go behind (11 months as you need). For better understanding you might want to learn more about set analysis. Set Analysis: syntaxes, examples

bharatkishore
Creator III
Creator III
Author

Thank u so much .... thanks for ur time n patience for explaining and thank u so much once again..