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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with a set that compare dates

Hi

How should I wright a set expression that shows the PersID for the following?

StartDate should be larger then EndDate but not larger then EndDate12

(EndDate12 = EndDate + 12 months. I create this in the script using addmonths)

1 Solution

Accepted Solutions
Not applicable
Author

I think I got one solution.

Count({$<StartDate={">$(=Date(EndDate))<$(=Date(EndDate12))"}>}PERSID)

View solution in original post

1 Reply
Not applicable
Author

I think I got one solution.

Count({$<StartDate={">$(=Date(EndDate))<$(=Date(EndDate12))"}>}PERSID)