Get a list of Agents without Policy in last 12 months (Set Analysis)

[rasunitha]

Dear Experts,

I am new to Qlik Sense and I have been stuck with this issue. 

Please find the mock data below:

Agents	Policies	Issue Date
Buil1	P1	14-Aug-20
Buil1	P2	21-Dec-15
Buil2	P3	5-Feb-14
Buil2	P4	3-Apr-19
Buil3	P5	9-Sep-17
Buil3	P6	14-Aug-20
Buil3	P7	3-Apr-19
Buil4	P8	16-Oct-19
Buil4	P9	5-Oct-19
Buil4	P10	24-Dec-18
Buil5	P11	22-Oct-18
Buil5	P12	31-Dec-17
Buil6	P13	24-Dec-18
Buil7	P14	22-Oct-18
Buil7	P15	9-Sep-17

I need to show a table with a list of Agents who didn't have any policies in the last 12 months (from the current date). My table should look like this.

Agents without Policies in last 12 Months

Buil2

Buil5

Buil6

Buil7

I used a Set Analysis as follows 

IF(SUM(AGGR( if( Date(Date#(POL_ISSUE_DATE, 'YYYYMMDD')) - Date#(Date(AddMonths(today(), -12)), 'DD/MM/YYYY') > 0 , 1,0)
,POLICIES))= 0,1,0)

But this does not seem to be working.

Any help would be greatly appreciated.

@sunny_talwar @tresesco 

Thank you.

Best Regards,

Sunitha

[tresesco · Accepted solution]

Try :

Aggr(Only({<Agents=e({<[Issue Date]={">=$(=Addmonths(Today(),-12))"}>})>}Agents), Agents)