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: 
qlikviewaf
Creator
Creator

Peek with filter

Hello,

i have this data set

i would like to define varibale "I04Date" as the lowest date on data set where surgery = I04

How this can be done?
Thank you!

DateSurgery
23/01/2021I04
28/01/2021I05
02/02/2021I23
07/02/2021I04
12/02/2021I04
17/02/2021 
22/02/2021I23
27/02/2021I08

 

 

 

1 Reply
MayilVahanan

Hi 

Try like below

I04Date = Date(Min({<Surgery={104}>}Date))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.