Creating chart with Sum expression and multiple condition

[#1]

I am trying to develop a bar chart.

In the expression tab i have two expressions.

One of them shows me the selection value, while other gives me a benchmark value.

Now for creating the benchmark bar i have to apply the following crtieria :

1. It follows a particular business line only.
2. It should not be affected by the salesman selection.

So i wrote the expression as

sum ( {<businessline={'RT'}>}  {<salesman_name=>} ear_prem_usd)

Now, because i have two conditions in the sume expressions, the second condition is overriding the first condition.

Please help....

Its really important and urgent...

[m_woolf]

sum ( {<businessline={'RT'},salesman_name=>} ear_prem_usd)

[jvitantonio]

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?

[#4]

Hi mwoolf,

I tried it, but it gives an syntax error for the expression

[m_woolf]

Can you attach a screen shot of the error?

[#6]

Attached is the error screenshot mwoolf.

[m_woolf · Accepted solution]

Remove the < in front of pname_pcd

[#8]

Hi mwoolf,

thnaks a lot for the help and guidance.

this has really solved my problem.

i am new to qv11. can you please provide me with some suggestions and tips.

[m_woolf]

Never used v11. Sorry.