topic Set analysis {1} doesn't seem to work in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-1-doesn-t-seem-to-work/m-p/394610#M147156 <HTML><HEAD></HEAD><BODY><P>Hi, I have a few text boxes on the right in my qvw. I want them to stay put regardless of the change. I tried using {1} in all the expressions but that doesn't seem to help. For example the Top scorer is 'Shane Watson' and i want this to stay regardless and all the items on the right side should be have that way. Please help.</P><P></P><P>Sorry I am new to qlikview apologies if the question is trivial.</P><P></P><P>thanks</P><P>Ram</P></BODY></HTML> Tue, 09 Oct 2012 13:27:37 GMT 2012-10-09T13:27:37Z Set analysis {1} doesn't seem to work https://community.qlik.com/t5/QlikView/Set-analysis-1-doesn-t-seem-to-work/m-p/394610#M147156 <HTML><HEAD></HEAD><BODY><P>Hi, I have a few text boxes on the right in my qvw. I want them to stay put regardless of the change. I tried using {1} in all the expressions but that doesn't seem to help. For example the Top scorer is 'Shane Watson' and i want this to stay regardless and all the items on the right side should be have that way. Please help.</P><P></P><P>Sorry I am new to qlikview apologies if the question is trivial.</P><P></P><P>thanks</P><P>Ram</P></BODY></HTML> Tue, 09 Oct 2012 13:27:37 GMT https://community.qlik.com/t5/QlikView/Set-analysis-1-doesn-t-seem-to-work/m-p/394610#M147156 2012-10-09T13:27:37Z Re: Set analysis {1} doesn't seem to work https://community.qlik.com/t5/QlikView/Set-analysis-1-doesn-t-seem-to-work/m-p/394611#M147157 <HTML><HEAD></HEAD><BODY><P>Hello Ram,</P><P></P><P>Not so trivial, actually:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13497896916246934" jivemacro_uid="_13497896916246934"><P>=FirstSortedValue({1} TOTAL &lt;Player&gt; Player, -Aggr(Max({1} Runs), Player))</P></PRE><P></P><P>Note that I'm using TOTAL along with the "{1}", and that the "{1}" as set is used in the Max() function as well.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Tue, 09 Oct 2012 13:35:26 GMT https://community.qlik.com/t5/QlikView/Set-analysis-1-doesn-t-seem-to-work/m-p/394611#M147157 Miguel_Angel_Baeyens 2012-10-09T13:35:26Z