Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add rolling 12 to this expression?

Hi

I have this expression

Sum(Aggr(If(Sum({<KVA = {'DV132'} >} _Flag_KVA) >= 2 and Count({<KVA = {'DV200'} >} P_ID) >=1, 1), P_ID, SurgeryID))

It shows me how many patients that have been coded as DV132 multiple times and also have been coded as DV200 on each Surgery-unit. Now I only want to get the patients that this occurs within the same 12 months period.

I have a master calender and have tried to add this expression without any result.

({<Year=, Month=, PeriodCounter = {">$(=max(PeriodCounter-12))<=$(=max(PeriodCounter))"} >}

Where should I put the Periodcounter expression? Or should I use any other way to solve it?

1 Reply
giakoum
Partner - Master II
Partner - Master II