topic How to make a single expression with certain condition in QlikView https://community.qlik.com/t5/QlikView/How-to-make-a-single-expression-with-certain-condition/m-p/230381#M82211 <HTML><HEAD></HEAD><BODY><P>Its not working..the values not displayed</P></BODY></HTML> Thu, 07 Oct 2010 09:21:53 GMT 2010-10-07T09:21:53Z How to make a single expression with certain condition https://community.qlik.com/t5/QlikView/How-to-make-a-single-expression-with-certain-condition/m-p/230379#M82209 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>I hv two expression given below i need it to convert into single expression with certain condition.</P><P>i hv two fields PeriodName and SEMName.</P><P>if i select PeriodName field values then expression(1) to be executed.</P><P>if i select SEMName field values then expression(2) to be executed.</P><P>(1)Sum ({$&lt;PeriodName={'$(=FIELDVALUE('PeriodName', FIELDINDEX('PeriodName', ONLY(PeriodName))-1))'}&gt;}Values)</P><P>(2)Sum ({$&lt;SEMName={'$(=FIELDVALUE('SEMName', FIELDINDEX('SEMName', ONLY(SEMName))-1))'}&gt;}Values)</P><P>Pls help me out</P></BODY></HTML> Thu, 07 Oct 2010 08:27:49 GMT https://community.qlik.com/t5/QlikView/How-to-make-a-single-expression-with-certain-condition/m-p/230379#M82209 2010-10-07T08:27:49Z How to make a single expression with certain condition https://community.qlik.com/t5/QlikView/How-to-make-a-single-expression-with-certain-condition/m-p/230380#M82210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can try this:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />=If(GetFieldSelections(PeriodName) &gt; 0, Expression1, if (GetFieldSelections(SEMName) &gt; 0, Expression2 ) )<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Thu, 07 Oct 2010 08:50:24 GMT https://community.qlik.com/t5/QlikView/How-to-make-a-single-expression-with-certain-condition/m-p/230380#M82210 2010-10-07T08:50:24Z How to make a single expression with certain condition https://community.qlik.com/t5/QlikView/How-to-make-a-single-expression-with-certain-condition/m-p/230381#M82211 <HTML><HEAD></HEAD><BODY><P>Its not working..the values not displayed</P></BODY></HTML> Thu, 07 Oct 2010 09:21:53 GMT https://community.qlik.com/t5/QlikView/How-to-make-a-single-expression-with-certain-condition/m-p/230381#M82211 2010-10-07T09:21:53Z