topic Re: Three conditional expression in QlikView https://community.qlik.com/t5/QlikView/Three-conditional-expression/m-p/523776#M483493 <HTML><HEAD></HEAD><BODY><P>Thank you guys. Those two seem to work. </P></BODY></HTML> Sun, 30 Jun 2013 10:22:11 GMT 2013-06-30T10:22:11Z Three conditional expression https://community.qlik.com/t5/QlikView/Three-conditional-expression/m-p/523773#M483490 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am struggling with something that seems relatively easy. </P><P>I need to use in my expressions three conditions:</P><P>A = 0</P><P>B &lt;&gt; 1</P><P>C &lt;&gt;2</P><P></P><P>Each condition comes from different table. I do not want to use list boxes for selection. I would like to have the conditions applied in the code. </P><P>What should be the expression for example for sum like =sum (conditions A,B,C) sales ? <SPAN style="font-size: 10pt;"> </SPAN></P></BODY></HTML> Sun, 30 Jun 2013 06:50:12 GMT https://community.qlik.com/t5/QlikView/Three-conditional-expression/m-p/523773#M483490 2013-06-30T06:50:12Z Re: Three conditional expression https://community.qlik.com/t5/QlikView/Three-conditional-expression/m-p/523774#M483491 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Try <SPAN style="color: #0000ff;">Sum</SPAN>({&lt;<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><SPAN style="color: #800000;">A</SPAN>={<SPAN style="color: #800000;">"0"</SPAN>},<SPAN style="color: #800000;">B</SPAN>={<SPAN style="color: #800000;">"&gt;1&lt;1"</SPAN>}<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">,<SPAN style="color: #800000;">C</SPAN>={<SPAN style="color: #800000;">"&gt;1&lt;1"</SPAN>}&gt;}<SPAN style="color: #800000;">Sales</SPAN>)</SPAN></SPAN></P><P></P><P><SPAN style="color: #737373; background-color: #ffffff; font-family: Arial;">BR</SPAN></P><P></P><P>Ariel</P></BODY></HTML> Sun, 30 Jun 2013 07:29:56 GMT https://community.qlik.com/t5/QlikView/Three-conditional-expression/m-p/523774#M483491 ariel_klien 2013-06-30T07:29:56Z Re: Three conditional expression https://community.qlik.com/t5/QlikView/Three-conditional-expression/m-p/523775#M483492 <HTML><HEAD></HEAD><BODY><P>Try sum({&lt;A={0},B-={1}&gt;,C-={2}&gt;}sales)</P></BODY></HTML> Sun, 30 Jun 2013 08:54:17 GMT https://community.qlik.com/t5/QlikView/Three-conditional-expression/m-p/523775#M483492 Gysbert_Wassenaar 2013-06-30T08:54:17Z Re: Three conditional expression https://community.qlik.com/t5/QlikView/Three-conditional-expression/m-p/523776#M483493 <HTML><HEAD></HEAD><BODY><P>Thank you guys. Those two seem to work. </P></BODY></HTML> Sun, 30 Jun 2013 10:22:11 GMT https://community.qlik.com/t5/QlikView/Three-conditional-expression/m-p/523776#M483493 2013-06-30T10:22:11Z