topic set analysis - disregard all selections except one in QlikView https://community.qlik.com/t5/QlikView/set-analysis-disregard-all-selections-except-one/m-p/366124#M136187 <HTML><HEAD></HEAD><BODY><P>How do i do this?</P><P></P><P>So, Sum ({1} Amount) would give me sum of all disregarding all selections. What i want is sum of all for 'business lead = current business lead selection' and disregarding all other selections.</P></BODY></HTML> Wed, 23 May 2012 16:53:14 GMT 2012-05-23T16:53:14Z set analysis - disregard all selections except one https://community.qlik.com/t5/QlikView/set-analysis-disregard-all-selections-except-one/m-p/366124#M136187 <HTML><HEAD></HEAD><BODY><P>How do i do this?</P><P></P><P>So, Sum ({1} Amount) would give me sum of all disregarding all selections. What i want is sum of all for 'business lead = current business lead selection' and disregarding all other selections.</P></BODY></HTML> Wed, 23 May 2012 16:53:14 GMT https://community.qlik.com/t5/QlikView/set-analysis-disregard-all-selections-except-one/m-p/366124#M136187 2012-05-23T16:53:14Z set analysis - disregard all selections except one https://community.qlik.com/t5/QlikView/set-analysis-disregard-all-selections-except-one/m-p/366125#M136188 <HTML><HEAD></HEAD><BODY><P>sum({&lt;Field1=,Field2=,Field3=,..........,[Business Lead]={[Current Business Lead Selection]}&gt;}Amount)</P></BODY></HTML> Wed, 23 May 2012 17:05:17 GMT https://community.qlik.com/t5/QlikView/set-analysis-disregard-all-selections-except-one/m-p/366125#M136188 goldnejea8 2012-05-23T17:05:17Z