topic Re: SET ANAYSIS in QlikView https://community.qlik.com/t5/QlikView/SET-ANAYSIS/m-p/80522#M768699 <HTML><HEAD></HEAD><BODY><P>Set analysis can only be used within an aggregation function. It seems that in order to ignore selection in Well.Name, you needed to use some aggregation function... and that is why only() is used. Alternatively, you can also use Concat, MinString, MaxString for string functions.</P></BODY></HTML> Tue, 26 Jun 2018 12:37:33 GMT sunny_talwar 2018-06-26T12:37:33Z SET ANAYSIS https://community.qlik.com/t5/QlikView/SET-ANAYSIS/m-p/80521#M768698 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Can any one tell me why in below logic only function is used?</P><P></P><P>ONLY({&lt;Well.Name= &gt;}IF(Storage.Name='Beer',C1))</P><P></P><P></P><P>Regards</P><P>Adarsh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/SET-ANAYSIS/m-p/80521#M768698 Anonymous 2020-11-25T16:16:04Z Re: SET ANAYSIS https://community.qlik.com/t5/QlikView/SET-ANAYSIS/m-p/80522#M768699 <HTML><HEAD></HEAD><BODY><P>Set analysis can only be used within an aggregation function. It seems that in order to ignore selection in Well.Name, you needed to use some aggregation function... and that is why only() is used. Alternatively, you can also use Concat, MinString, MaxString for string functions.</P></BODY></HTML> Tue, 26 Jun 2018 12:37:33 GMT https://community.qlik.com/t5/QlikView/SET-ANAYSIS/m-p/80522#M768699 sunny_talwar 2018-06-26T12:37:33Z Re: SET ANAYSIS https://community.qlik.com/t5/QlikView/SET-ANAYSIS/m-p/80523#M768700 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny , it was helpful !! </P></BODY></HTML> Tue, 26 Jun 2018 12:43:46 GMT https://community.qlik.com/t5/QlikView/SET-ANAYSIS/m-p/80523#M768700 Anonymous 2018-06-26T12:43:46Z