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: 
gradiske
Contributor III
Contributor III

how to exclude dates between dates that already exists

Sorry guys, i was trying to edit with my smartphone yesterday and something went wrong =/

10 Replies
gradiske
Contributor III
Contributor III
Author

Ajay, now i've got another situation. Using your example, sometimes this occurs:

useridstart_Datefinal_Dateflag_deleteaudience
3520/06/201330/06/2013N0,36666666666667
3522/07/201331/07/2013N0,33333333333333
3522/07/201309/11/2013N3,7
3502/09/201301/10/2013Y1
3510/11/201303/12/2013N0,8

Note that the row n2 dates are between the row n3. Assuming that peek() are getting only the previous record, how can i handle that?