topic Re: If function and hopefully explantaion in QlikView https://community.qlik.com/t5/QlikView/If-function-and-hopefully-explantaion/m-p/1111739#M917826 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Sum({&lt;Indicator = {220}&gt;} Numerator)</STRONG></SPAN></P><P></P><P>or</P><P></P><P><STRONG style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Sum(TOTAL {&lt;Indicator = {220}&gt;} Numerator)</STRONG></P></BODY></HTML> Tue, 10 May 2016 17:22:41 GMT sunny_talwar 2016-05-10T17:22:41Z If function and hopefully explantaion https://community.qlik.com/t5/QlikView/If-function-and-hopefully-explantaion/m-p/1111738#M917825 <HTML><HEAD></HEAD><BODY><P>Hello I have a problem where I have a list of ID's and I only want the numerator for one so i have tried this expression</P><P></P><P>=if(match([Indicator ID]=220,sum(TOTAL(Numerator)))</P><P></P><P>but there is something wrong with the IF function, could anyone give me a solution and possibly an explantion of how IF functions work so that I could understand as I am being confused by it?</P><P></P><P>Thanks in advance for any answers</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/If-function-and-hopefully-explantaion/m-p/1111738#M917825 2020-11-25T16:16:04Z Re: If function and hopefully explantaion https://community.qlik.com/t5/QlikView/If-function-and-hopefully-explantaion/m-p/1111739#M917826 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Sum({&lt;Indicator = {220}&gt;} Numerator)</STRONG></SPAN></P><P></P><P>or</P><P></P><P><STRONG style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Sum(TOTAL {&lt;Indicator = {220}&gt;} Numerator)</STRONG></P></BODY></HTML> Tue, 10 May 2016 17:22:41 GMT https://community.qlik.com/t5/QlikView/If-function-and-hopefully-explantaion/m-p/1111739#M917826 sunny_talwar 2016-05-10T17:22:41Z