Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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