Qlik Community

Ask a Question

New to Qlik Sense

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Add date to set analysis

Hi everyone, 

I am filtering a table column by the following: 

=if(Calendar ='ReferralDate' and SuicideReferralFlagName='Yes' and ReferralEpisode_SuicideReferral_BinaryFlag=1 and SCNoShowId=2 and SCClientParticipationIndicatorId=1, ReferralNumber)

I only want to count the referral number if SCNoShowId=2 and SCClientParticipationIndicatorId=1 on the first service contact date, so something like this needs to be added to the set analysis but I can't get it working:

=Date(Min([SCServiceContactDate],ReferralNumber))

 

Thank you 

 

Labels (3)
1 Solution

Accepted Solutions
Saravanan_Desingh

Try this.

Count({<SCServiceContactDate={'$(Date(=Min([SCServiceContactDate])))'},SCNoShowId={2},SCClientParticipationIndicatorId={1}>} ReferralNumber)

View solution in original post

2 Replies
Saravanan_Desingh

Try this.

Count({<SCServiceContactDate={'$(Date(=Min([SCServiceContactDate])))'},SCNoShowId={2},SCClientParticipationIndicatorId={1}>} ReferralNumber)

View solution in original post

Taylorcc
Contributor III
Contributor III
Author

Perfect, thank you!