topic Expression in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/962252#M956171 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>How to write below expressions</P><P></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 412px;"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="133"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">expression</SPAN></TD><TD style="border: 0px black; border-image: none;" width="279"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">if (BS_TYPE = 'OFB', ead, '') </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">expression</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">if (BS_TYPE = 'OFB', '', ead) </SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>*ead = sum(ead)</P><P></P><P>Is it possible in setanalysis</P></BODY></HTML> Mon, 09 Nov 2015 11:52:51 GMT priyarane 2015-11-09T11:52:51Z Expression https://community.qlik.com/t5/QlikView/Expression/m-p/962252#M956171 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>How to write below expressions</P><P></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 412px;"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="133"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">expression</SPAN></TD><TD style="border: 0px black; border-image: none;" width="279"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">if (BS_TYPE = 'OFB', ead, '') </SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">expression</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">if (BS_TYPE = 'OFB', '', ead) </SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>*ead = sum(ead)</P><P></P><P>Is it possible in setanalysis</P></BODY></HTML> Mon, 09 Nov 2015 11:52:51 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/962252#M956171 priyarane 2015-11-09T11:52:51Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/962253#M956172 <HTML><HEAD></HEAD><BODY><P>you can write it as if(BS_TYPE = 'OFB', sum(ead)) or sum({&lt;BS_TYPE={'OFB'}&gt;}ead)</P></BODY></HTML> Mon, 09 Nov 2015 11:55:09 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/962253#M956172 maleksafa 2015-11-09T11:55:09Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/962254#M956173 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>sum({$&lt;<SPAN style="color: #000000; font-family: Calibri; font-size: 16px;">BS_TYPE = {'OFB'}</SPAN>&gt;} ead)</STRONG></P></BODY></HTML> Mon, 09 Nov 2015 11:55:30 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/962254#M956173 miguelbraga 2015-11-09T11:55:30Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/962255#M956174 <HTML><HEAD></HEAD><BODY><P>=sum({&lt;BS_TYPE={'OFB'} &gt;} ead)</P></BODY></HTML> Mon, 09 Nov 2015 12:00:56 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/962255#M956174 Anonymous 2015-11-09T12:00:56Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/962256#M956175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have tried below one</P><P></P><P>1 expr -</P><P></P><P>if(BS_TYPE='OFB', (Sum(EAD),0)</P><P></P><P></P><P>2. expr</P><P></P><P>if(BS_TYPE='OFB',0, (Sum(EAD))</P><P><SPAN class="mce_paste_marker"></SPAN></P></BODY></HTML> Mon, 09 Nov 2015 12:41:39 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/962256#M956175 priyarane 2015-11-09T12:41:39Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/962257#M956176 <HTML><HEAD></HEAD><BODY><P>Missing bracket:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">1 expr -</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(BS_TYPE='OFB', (Sum(EAD)),0)</P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">2. expr</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(BS_TYPE='OFB',0, (Sum(EAD)))</P></BODY></HTML> Mon, 09 Nov 2015 12:44:43 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/962257#M956176 Anonymous 2015-11-09T12:44:43Z