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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
smanas
Contributor III
Contributor III

Get only current enrollment and one previous enrollment and end date for each ID using an expression in AdHoc Qliksense

Hi I'm trying a Qlicksense expression to achieve the below

1. Get only the current and one previous enrollment and end date. 

2. Compare the current enrollment date and previous end date if previous end date >6months of current enrollment date then flag ID 1 as new else old.

smanas_0-1677524540429.png

In the above example rows the output should show as below as solved by @vinieme12 

smanas_1-1677524675478.png

Please advise. Thank you

 

 

Labels (2)
0 Replies