topic Re: Creating chart with Sum expression and multiple condition in QlikView https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383946#M491660 <HTML><HEAD></HEAD><BODY><P>Remove the &lt; in front of pname_pcd</P></BODY></HTML> Tue, 04 Sep 2012 15:09:16 GMT m_woolf 2012-09-04T15:09:16Z Creating chart with Sum expression and multiple condition https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383940#M491654 <HTML><HEAD></HEAD><BODY><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">I am trying to develop a bar chart.</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">In the expression tab i have two expressions.</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">One of them shows me the selection value, while other gives me a benchmark value.</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">Now for creating the benchmark bar i have to apply the following crtieria :</P><OL style="background-color: #eef4f9; font-size: 12px; list-style-position: initial; list-style-image: initial; padding: 0 0 0 2.25em; color: #636363; font-family: Arial;"><LI>It follows a particular business line only.</LI><LI>It should not be affected by the salesman selection.</LI></OL><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">So i wrote the expression as</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">sum ( {&lt;businessline={'RT'}&gt;}&nbsp; {&lt;salesman_name=&gt;} ear_prem_usd)</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">Now, because i have two conditions in the sume expressions, the second condition is overriding the first condition.</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">Please help....</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">Its really important and urgent...</P></BODY></HTML> Tue, 04 Sep 2012 14:42:51 GMT https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383940#M491654 2012-09-04T14:42:51Z Re: Creating chart with Sum expression and multiple condition https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383941#M491655 <HTML><HEAD></HEAD><BODY><P style="background-color: #eef4f9; font-family: Arial; color: #636363; font-size: 12px;">sum ( {&lt;businessline={'RT'},salesman_name=&gt;} ear_prem_usd)</P></BODY></HTML> Tue, 04 Sep 2012 14:55:14 GMT https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383941#M491655 m_woolf 2012-09-04T14:55:14Z Re: Creating chart with Sum expression and multiple condition https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383942#M491656 <HTML><HEAD></HEAD><BODY><P>Hi, you have 2 conditions because you need them. What's wrong with this? The first condition says to sum all business line = 'RT' while the second one says it will sum ALL salesman with businessline = 'RT' . Is this what you need?</P></BODY></HTML> Tue, 04 Sep 2012 14:56:42 GMT https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383942#M491656 jvitantonio 2012-09-04T14:56:42Z Re: Creating chart with Sum expression and multiple condition https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383943#M491657 <HTML><HEAD></HEAD><BODY><P>Hi mwoolf,</P><P></P><P>I tried it, but it gives an syntax error for the expression</P></BODY></HTML> Tue, 04 Sep 2012 15:01:07 GMT https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383943#M491657 2012-09-04T15:01:07Z Re: Creating chart with Sum expression and multiple condition https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383944#M491658 <HTML><HEAD></HEAD><BODY><P>Can you attach a screen shot of the error?</P></BODY></HTML> Tue, 04 Sep 2012 15:04:37 GMT https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383944#M491658 m_woolf 2012-09-04T15:04:37Z Re: Creating chart with Sum expression and multiple condition https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383945#M491659 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="21317" class="jive-image-thumbnail jive-image" onclick="" alt="error.jpg" src="https://community.qlik.com/legacyfs/online/21317_error.jpg" width="450" /></P><P>Attached is the error screenshot mwoolf.</P></BODY></HTML> Tue, 04 Sep 2012 15:06:57 GMT https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383945#M491659 2012-09-04T15:06:57Z Re: Creating chart with Sum expression and multiple condition https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383946#M491660 <HTML><HEAD></HEAD><BODY><P>Remove the &lt; in front of pname_pcd</P></BODY></HTML> Tue, 04 Sep 2012 15:09:16 GMT https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383946#M491660 m_woolf 2012-09-04T15:09:16Z Re: Creating chart with Sum expression and multiple condition https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383947#M491661 <HTML><HEAD></HEAD><BODY><P>Hi mwoolf,</P><P></P><P>thnaks a lot for the help and guidance. </P><P></P><P>this has really solved my problem.</P><P></P><P>i am new to qv11. can you please provide me with some suggestions and tips.</P></BODY></HTML> Tue, 04 Sep 2012 15:12:36 GMT https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383947#M491661 2012-09-04T15:12:36Z Re: Creating chart with Sum expression and multiple condition https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383948#M491662 <HTML><HEAD></HEAD><BODY><P>Never used v11. Sorry.</P></BODY></HTML> Tue, 04 Sep 2012 15:13:52 GMT https://community.qlik.com/t5/QlikView/Creating-chart-with-Sum-expression-and-multiple-condition/m-p/383948#M491662 m_woolf 2012-09-04T15:13:52Z