topic Re: Static Variable in QlikView https://community.qlik.com/t5/QlikView/Static-Variable/m-p/742825#M265247 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try with&nbsp; vCurrentYrQtr =max({1}QuarterNum), where {1} excludes all selections.</P><P></P><P>BR,</P><P>Elena</P></BODY></HTML> Wed, 18 Feb 2015 09:46:14 GMT Anonymous 2015-02-18T09:46:14Z Static Variable https://community.qlik.com/t5/QlikView/Static-Variable/m-p/742824#M265246 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to create static variable for max QuaterNum.</P><P>I created variable like vCurrentYrQtr = Max(QuaterNum).</P><P>However it is working on current selection.</P><P>For instance: vCurrentYrQtr is '20151 but if click year as 2014 and quarter as 4 by the time it shows vCurrentYrQtr is '20144'.</P><P>My requirement is if i click any year and quarter the variable should show only max QuaterNum like '20151'.</P><P></P><P>Regards,</P><P>Nihhal.</P></BODY></HTML> Wed, 18 Feb 2015 08:40:31 GMT https://community.qlik.com/t5/QlikView/Static-Variable/m-p/742824#M265246 nihhalmca 2015-02-18T08:40:31Z Re: Static Variable https://community.qlik.com/t5/QlikView/Static-Variable/m-p/742825#M265247 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try with&nbsp; vCurrentYrQtr =max({1}QuarterNum), where {1} excludes all selections.</P><P></P><P>BR,</P><P>Elena</P></BODY></HTML> Wed, 18 Feb 2015 09:46:14 GMT https://community.qlik.com/t5/QlikView/Static-Variable/m-p/742825#M265247 Anonymous 2015-02-18T09:46:14Z Re: Static Variable https://community.qlik.com/t5/QlikView/Static-Variable/m-p/742826#M265248 <HTML><HEAD></HEAD><BODY><P>Thanks Elena</P></BODY></HTML> Wed, 18 Feb 2015 10:05:24 GMT https://community.qlik.com/t5/QlikView/Static-Variable/m-p/742826#M265248 nihhalmca 2015-02-18T10:05:24Z