I am trying to return summed data in Qlik Sense for the prior month based on a selected month.
I have a field called STATUS which has various entries, one of which is NEW BUSINESS and one is INFORCE. Each of these have Net Written Premium figures against them. The NEW BUSINESS entries can be against any day in a month whereas the INFORCE entries are all set to the last day of each month.
When the NEW BUSINESS Net Written Premium data is selected I need to return the INFORCE Net Written Premium from the prior month.
|STATUS||Row Extract Date||Net Written Premium|
Using the data above, if January 2018 was selected, £80 would show as NEW BUSINESS and £325 would show as INFORCE.
Any help will be gratefully received!