topic Re: Peek with filter in QlikView

topic Re: Peek with filter in QlikView https://community.qlik.com/t5/QlikView/Peek-with-filter/m-p/1837526#M1215008 <P>Hi </P><P>Try like below</P><P><SPAN>I04Date = Date(Min({<Surgery={104}>}Date))</SPAN></P> Mon, 20 Sep 2021 09:13:48 GMT MayilVahanan 2021-09-20T09:13:48Z Peek with filter https://community.qlik.com/t5/QlikView/Peek-with-filter/m-p/1837513#M1215006 <P>Hello,</P><P>i have this data set</P><P>i would like to define varibale "I04Date" as the lowest date on data set where surgery = I04</P><P>How this can be done?<BR />Thank you!</P><TABLE><TBODY><TR><TD>Date</TD><TD>Surgery</TD></TR><TR><TD>23/01/2021</TD><TD>I04</TD></TR><TR><TD>28/01/2021</TD><TD>I05</TD></TR><TR><TD>02/02/2021</TD><TD>I23</TD></TR><TR><TD>07/02/2021</TD><TD>I04</TD></TR><TR><TD>12/02/2021</TD><TD>I04</TD></TR><TR><TD>17/02/2021</TD><TD> </TD></TR><TR><TD>22/02/2021</TD><TD>I23</TD></TR><TR><TD>27/02/2021</TD><TD>I08</TD></TR></TBODY></TABLE><P> </P><P> </P><P> </P> Mon, 20 Sep 2021 08:53:00 GMT https://community.qlik.com/t5/QlikView/Peek-with-filter/m-p/1837513#M1215006 qlikviewaf 2021-09-20T08:53:00Z Re: Peek with filter https://community.qlik.com/t5/QlikView/Peek-with-filter/m-p/1837526#M1215008 <P>Hi </P><P>Try like below</P><P><SPAN>I04Date = Date(Min({<Surgery={104}>}Date))</SPAN></P> Mon, 20 Sep 2021 09:13:48 GMT https://community.qlik.com/t5/QlikView/Peek-with-filter/m-p/1837526#M1215008 MayilVahanan 2021-09-20T09:13:48Z