Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
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 (3)
0 Replies