Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

Can someone help me with some set analysis please?

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. 

My data model looks like this, it's joined at %Master_Id:

samvile18_0-1721911153048.png

I'm struggling to get the syntax to work for the set analysis...can anyone help me please?

Labels (1)
1 Reply
SterreKapteijns
Partner Ambassador
Partner Ambassador

I am not really sure what the Master_Id field represents.. but if the Master_Id is the unique login ID:

count({< LoginDate = {"=LoginDate >= CampaignDate and LoginDate <= CampaginDate + 30" } >} distinct %Master_Id)