topic Re: Conditional Expressions with multiple conditions in QlikView https://community.qlik.com/t5/QlikView/Conditional-Expressions-with-multiple-conditions/m-p/459125#M171366 <HTML><HEAD></HEAD><BODY><P>Hi Ihan,</P><P></P><P>So you want the expression as to be </P><P><STRONG>=if(<EM style="background-color: #ffffff; color: #737373; font-family: Arial;">mSalesAmount </EM>=1 and <EM style="background-color: #ffffff; color: #737373; font-family: Arial;"><EM>mSalesQty</EM> </EM>=1,1,0)</STRONG></P><P></P><P><STRONG>This can be a way to get this .<BR /></STRONG></P></BODY></HTML> Tue, 11 Jun 2013 10:09:44 GMT sujeetsingh 2013-06-11T10:09:44Z Conditional Expressions with multiple conditions https://community.qlik.com/t5/QlikView/Conditional-Expressions-with-multiple-conditions/m-p/459122#M171363 <HTML><HEAD></HEAD><BODY><P>Is it possible to show an Expression up on two conditions:</P><P></P><P>In a table I have a condition on an exspression saying "=<EM>mSalesAmount</EM>" where <EM>mSalesAmount</EM> is a variable. Hence, the expression is shown only when the variable equals 1. I would like to attached another condition to the expression (e.g. "=<EM>mSalesQty</EM>").</P><P></P><P>Is it possible to make a kind of "and" statement in the conditions? (e.g. "=and(<EM>mSalesAmount</EM>, <EM>mSalesQty</EM>)")</P></BODY></HTML> Tue, 11 Jun 2013 09:37:38 GMT https://community.qlik.com/t5/QlikView/Conditional-Expressions-with-multiple-conditions/m-p/459122#M171363 2013-06-11T09:37:38Z Re: Conditional Expressions with multiple conditions https://community.qlik.com/t5/QlikView/Conditional-Expressions-with-multiple-conditions/m-p/459123#M171364 <HTML><HEAD></HEAD><BODY><P><EM style="background-color: #ffffff; color: #737373; font-family: Arial;">mSalesAmount = 1 and <EM style="background-color: #ffffff; color: #737373; font-family: Arial;">mSalesQty</EM> = 1 ?</EM></P></BODY></HTML> Tue, 11 Jun 2013 10:06:05 GMT https://community.qlik.com/t5/QlikView/Conditional-Expressions-with-multiple-conditions/m-p/459123#M171364 2013-06-11T10:06:05Z Re: Conditional Expressions with multiple conditions https://community.qlik.com/t5/QlikView/Conditional-Expressions-with-multiple-conditions/m-p/459124#M171365 <HTML><HEAD></HEAD><BODY><P>Ok - that was easy <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 11 Jun 2013 10:09:25 GMT https://community.qlik.com/t5/QlikView/Conditional-Expressions-with-multiple-conditions/m-p/459124#M171365 2013-06-11T10:09:25Z Re: Conditional Expressions with multiple conditions https://community.qlik.com/t5/QlikView/Conditional-Expressions-with-multiple-conditions/m-p/459125#M171366 <HTML><HEAD></HEAD><BODY><P>Hi Ihan,</P><P></P><P>So you want the expression as to be </P><P><STRONG>=if(<EM style="background-color: #ffffff; color: #737373; font-family: Arial;">mSalesAmount </EM>=1 and <EM style="background-color: #ffffff; color: #737373; font-family: Arial;"><EM>mSalesQty</EM> </EM>=1,1,0)</STRONG></P><P></P><P><STRONG>This can be a way to get this .<BR /></STRONG></P></BODY></HTML> Tue, 11 Jun 2013 10:09:44 GMT https://community.qlik.com/t5/QlikView/Conditional-Expressions-with-multiple-conditions/m-p/459125#M171366 sujeetsingh 2013-06-11T10:09:44Z Re: Conditional Expressions with multiple conditions https://community.qlik.com/t5/QlikView/Conditional-Expressions-with-multiple-conditions/m-p/459126#M171367 <HTML><HEAD></HEAD><BODY><P>Hi Son of Sardar,</P><P></P><P>As Fantasamagoria suggested I can actually do it without the if()..</P></BODY></HTML> Tue, 11 Jun 2013 10:11:13 GMT https://community.qlik.com/t5/QlikView/Conditional-Expressions-with-multiple-conditions/m-p/459126#M171367 2013-06-11T10:11:13Z