topic Set analysis - specific field in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-specific-field/m-p/1301168#M831780 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to create a formula that is...</P><P></P><P>sum(Revenue)-sum(OtherRevenue) where field (or dimension) is LOB.</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT hjm35055 2020-11-25T16:16:04Z Set analysis - specific field https://community.qlik.com/t5/QlikView/Set-analysis-specific-field/m-p/1301168#M831780 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to create a formula that is...</P><P></P><P>sum(Revenue)-sum(OtherRevenue) where field (or dimension) is LOB.</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-analysis-specific-field/m-p/1301168#M831780 hjm35055 2020-11-25T16:16:04Z Re: Set analysis - specific field https://community.qlik.com/t5/QlikView/Set-analysis-specific-field/m-p/1301169#M831781 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this,</P><P><STRONG>Expression:</STRONG></P><P>sum({&lt;dimension={'LOB'}&gt;}Revenue)-sum({&lt;dimension={'LOB'}&gt;}OtherRevenue) </P><P></P><P>Hope this helps you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards,</P><P>Deva</P></BODY></HTML> Fri, 16 Jun 2017 03:16:26 GMT https://community.qlik.com/t5/QlikView/Set-analysis-specific-field/m-p/1301169#M831781 devarasu07 2017-06-16T03:16:26Z