Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
jwusko
Contributor II
Contributor II

Using Expression to create Segment Boundaries?

Using a date for Segment Boundaries, can I use expressions, for example:

DATETIME(SYSTEMDATE, +60 days)

DATETIME(SYSTEMDATE, +90 days)

DATETIME(SYSTEMDATE, +180 day)

DATETIME(SYSTEMDATE, +270 day)

 

Labels (2)
1 Solution

Accepted Solutions
john_wang
Support
Support

Hello @jwusko ,

Welcome to Qlik Community!

I'm afraid no. This expression gets dynamic datatime values so the result maybe impacted. For example you startup the task at 11:59PM to process the 1st segement and after some minutes, while Replicate start to process another segment, the system date was changed and you get different result.

Hope this helps.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

3 Replies
john_wang
Support
Support

Hello @jwusko ,

Welcome to Qlik Community!

I'm afraid no. This expression gets dynamic datatime values so the result maybe impacted. For example you startup the task at 11:59PM to process the 1st segement and after some minutes, while Replicate start to process another segment, the system date was changed and you get different result.

Hope this helps.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
jwusko
Contributor II
Contributor II
Author

Thank you John!

jwusko
Contributor II
Contributor II
Author

Just to confirm, though, the functionality to use an expression in the segment boundary doesn't exist...not just the use of the date?