https://community.qlik.com/t5/App-Development/max-total-date-with-where-condition/m-p/1792944#M62074 <P>Have you tried using set analysis?</P><P><SPAN>max({$&lt;company_id={'XXXXX'},myfield={'XXXXX'}&gt;} total date)</SPAN></P> Fri, 19 Mar 2021 15:28:39 GMT GaryGiles 2021-03-19T15:28:39Z https://community.qlik.com/t5/App-Development/max-total-date-with-where-condition/m-p/1792871#M62063 <P>Hi guys,</P><P>I want to create a variable which I will use further in NPrinting "Enable dynamic naming".</P><P>max(total date) where company_id = 'XXXXX' and where in myfield = 'XXXXX'.</P><P>Can someone help?</P><P>BR,</P><P>Artur</P> Sat, 16 Nov 2024 00:24:17 GMT https://community.qlik.com/t5/App-Development/max-total-date-with-where-condition/m-p/1792871#M62063 Uri 2024-11-16T00:24:17Z https://community.qlik.com/t5/App-Development/max-total-date-with-where-condition/m-p/1792944#M62074 <P>Have you tried using set analysis?</P><P><SPAN>max({$&lt;company_id={'XXXXX'},myfield={'XXXXX'}&gt;} total date)</SPAN></P> Fri, 19 Mar 2021 15:28:39 GMT https://community.qlik.com/t5/App-Development/max-total-date-with-where-condition/m-p/1792944#M62074 GaryGiles 2021-03-19T15:28:39Z https://community.qlik.com/t5/App-Development/max-total-date-with-where-condition/m-p/1792979#M62081 <P>Cool! It works.</P><P>Thanks!</P><P>How can I convert this to a variable?</P> Fri, 19 Mar 2021 17:17:01 GMT https://community.qlik.com/t5/App-Development/max-total-date-with-where-condition/m-p/1792979#M62081 Uri 2021-03-19T17:17:01Z https://community.qlik.com/t5/App-Development/max-total-date-with-where-condition/m-p/1792989#M62082 <P>Just paste the expression into the definition of the variable and then use the $-expansion</P><P>&nbsp;</P><P>$(vVariable)</P><P>&nbsp;</P><P>Assuming vVariable is the name of your variable.</P> Fri, 19 Mar 2021 17:47:57 GMT https://community.qlik.com/t5/App-Development/max-total-date-with-where-condition/m-p/1792989#M62082 GaryGiles 2021-03-19T17:47:57Z