topic Using Expression to create Segment Boundaries? in Qlik Replicate

Using Expression to create Segment Boundaries?

jwusko — Fri, 16 Jun 2023 03:16:05 GMT

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)

Re: Using Expression to create Segment Boundaries?

john_wang — Fri, 16 Jun 2023 03:39:33 GMT

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.

Re: Using Expression to create Segment Boundaries?

jwusko — Fri, 16 Jun 2023 09:28:14 GMT

Thank you John!

Re: Using Expression to create Segment Boundaries?

jwusko — Fri, 16 Jun 2023 13:26:44 GMT

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