Skip to main content
Announcements
New: No-code data prep in Qlik Cloud Analytics™ TAKE A TOUR
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Calendar link in set analysis

Hi everyone, 

 

I am using this set analysis which is working perfectly fine -

=count({<Referral_Number = p({<[ServiceContact_K10+_ ServiceContact_ReasonForCollection]={"Episode start"}>})
* p({<[ServiceContact_K10+_ ServiceContact_ReasonForCollection]={"Episode end"},
Calendar ='Referral_End_Date',
Referral_CompletionStatus-={"Episode Open"}
>}) >}
distinct Referral_Number)

I need to add - Calendar ='Referral_End_Date' to the set analysis but can not get it to work 

Any ideas? 

 

Thank you 

Labels (2)
0 Replies