Day Function

[Qlik2021]

Hello Community,

I 'm very new to the Qlik sense Enterprise.

right now I have struggled to create the customer category based on the order days :

Repeat Customer = last order date =or< 365 days ago

Reactivated Customer  = last order date >365 days ago

New  Customer= Last order date does not exist

Please give any advice or samples for the solutions.

Thank you !!

[Andreas_Giesbrecht]

Hi Qlik2021,

Thank you for reaching out.

What kind of issues did you have when trying to create those customer categories based on the order dates?

Was the issue with the time calculation or how to setup the categories in general? 

For such requests it could also be helpful to provide a simple app (including your script).

Thanks!