topic Set variable expression via Action using max() in QlikView https://community.qlik.com/t5/QlikView/Set-variable-expression-via-Action-using-max/m-p/586408#M478832 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">How would I return the Max record ID in this variable expression if the user chooses to go past it?</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">the last part wont work</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=If(vCountryID &lt; max(vCountryID) , '$(vCountryID)'+1 ,<SPAN style="font-style: inherit; font-family: inherit;"><STRONG> max(CountryID)</STRONG></SPAN>&nbsp; )</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><IMG __jive_id="54041" alt="2014-02-28_105433.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54041_2014-02-28_105433.png" /></P></BODY></HTML> Fri, 28 Feb 2014 15:55:24 GMT b_garside 2014-02-28T15:55:24Z Set variable expression via Action using max() https://community.qlik.com/t5/QlikView/Set-variable-expression-via-Action-using-max/m-p/586408#M478832 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">How would I return the Max record ID in this variable expression if the user chooses to go past it?</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">the last part wont work</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=If(vCountryID &lt; max(vCountryID) , '$(vCountryID)'+1 ,<SPAN style="font-style: inherit; font-family: inherit;"><STRONG> max(CountryID)</STRONG></SPAN>&nbsp; )</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><IMG __jive_id="54041" alt="2014-02-28_105433.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54041_2014-02-28_105433.png" /></P></BODY></HTML> Fri, 28 Feb 2014 15:55:24 GMT https://community.qlik.com/t5/QlikView/Set-variable-expression-via-Action-using-max/m-p/586408#M478832 b_garside 2014-02-28T15:55:24Z Re: Set variable expression via Action using max() https://community.qlik.com/t5/QlikView/Set-variable-expression-via-Action-using-max/m-p/586409#M478833 <HTML><HEAD></HEAD><BODY><P>figured it out. Very much like set analysis.</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=If(vCountryID &lt; max(vCountryID) , '$(vCountryID)'+1 ,</SPAN><STRONG><SPAN style="font-style: inherit; font-family: inherit; color: #3d3d3d;"> </SPAN>$(=max(CountryID))</STRONG> )</P></BODY></HTML> Fri, 28 Feb 2014 16:03:09 GMT https://community.qlik.com/t5/QlikView/Set-variable-expression-via-Action-using-max/m-p/586409#M478833 b_garside 2014-02-28T16:03:09Z