Discussion board where members can get started with Qlik Sense.
I need to create a measure with the sum of MedicalExpenses from the last 12 months just for the unsubscribed Members in the current month.
How can I accomplish that requirement?
Columns: MedicalExpenses , Members , UnsubscribedMembers
need more details to help properly but you can use set analysis to achieve it.
something like below
refer below for more on set analysis