https://community.qlik.com/t5/App-Development/Can-someone-help-me-with-some-set-analysis-please/m-p/2472967#M99829 <P>Hi everyone - I'm trying to count the amount of logins in a 30 day window after a campaign my campaign date. So essentially, count the amount of logins that occur within 30 days of the CampaignDate.&nbsp;</P> <P>My data model looks like this, it's joined at %Master_Id:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="samvile18_0-1721911153048.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169926i8713FC5203C21890/image-size/medium?v=v2&amp;px=400" role="button" title="samvile18_0-1721911153048.png" alt="samvile18_0-1721911153048.png" /></span></P> <P>I'm struggling to get the syntax to work for the set analysis...can anyone help me please?</P> Thu, 25 Jul 2024 12:40:06 GMT samvile18 2024-07-25T12:40:06Z https://community.qlik.com/t5/App-Development/Can-someone-help-me-with-some-set-analysis-please/m-p/2472967#M99829 <P>Hi everyone - I'm trying to count the amount of logins in a 30 day window after a campaign my campaign date. So essentially, count the amount of logins that occur within 30 days of the CampaignDate.&nbsp;</P> <P>My data model looks like this, it's joined at %Master_Id:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="samvile18_0-1721911153048.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169926i8713FC5203C21890/image-size/medium?v=v2&amp;px=400" role="button" title="samvile18_0-1721911153048.png" alt="samvile18_0-1721911153048.png" /></span></P> <P>I'm struggling to get the syntax to work for the set analysis...can anyone help me please?</P> Thu, 25 Jul 2024 12:40:06 GMT https://community.qlik.com/t5/App-Development/Can-someone-help-me-with-some-set-analysis-please/m-p/2472967#M99829 samvile18 2024-07-25T12:40:06Z https://community.qlik.com/t5/App-Development/Can-someone-help-me-with-some-set-analysis-please/m-p/2473616#M99913 <P>I am not really sure what the Master_Id field represents.. but if the Master_Id is the unique login ID:</P> <P>count({&lt;&nbsp;LoginDate = {"=LoginDate &gt;= CampaignDate and LoginDate &lt;= CampaginDate + 30" } &gt;} distinct %Master_Id)</P> Mon, 29 Jul 2024 16:58:24 GMT https://community.qlik.com/t5/App-Development/Can-someone-help-me-with-some-set-analysis-please/m-p/2473616#M99913 SterreKapteijns 2024-07-29T16:58:24Z