Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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