Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Sum last 12 month from current month dimension value

Hi,

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

 

Thanks,

Facundo

2 Replies
Highlighted
Partner
Partner

need more details to help properly but you can use set analysis to achieve it.

something like below

Sum({<Type={'Unsubscribed'}, Date={">=$(=AddMonths(today(),-12))"}>}SalesAmount)

 

refer below for more on set analysis

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Highlighted
Specialist III
Specialist III

Sum({<Type={'Unsubscribed'}, Date={">=$(=Monthstart(AddMonths(today(),-12)))"}>}SalesAmount)

Channa