topic Re: Help with expression in QlikView

Help with expression

Thu, 05 Jun 2014 21:55:23 GMT

I need some held with the expression for the Total Sales column

In the Total Sales column i want to have the calculation

sum (sales) where account_manager_id from Staff_Table = sales_person_id in Sales_Table

The total sales shall include all sales from each account manager, doesn't matter if he/she is responsible for that account or not.

If someone please can help me code the expression that is needed.

Fri, 06 Jun 2014 00:04:40 GMT

Hi Johan,

Can you post an example? Otherwise, perhaps this will work:

sum(if(account_manager_id = sales_person_id, sales))

Best,

Matt

Fri, 06 Jun 2014 00:21:23 GMT

This is almost correct, the only thing is that it only shows me the total sales where the account manager is the same.

The correct amount in this example should be 6,3 million

Fri, 06 Jun 2014 08:34:00 GMT

*bump*

tresB — Fri, 06 Jun 2014 08:40:14 GMT

Had your attachment been in English, would have been easier. Not sure if understood right. Try with set analysis p(), like:

=sum({<account_manager_id = p(sales_person_id)>} sales)

Sun, 08 Jun 2014 23:07:09 GMT

Hi Johan,

I'm still unclear on what you need. This makes sense to me and is solved with the sum/if expression:

sum (sales) where account_manager_id from Staff_Table = sales_person_id in Sales_Table.

However, I'm not sure how to interpret this:

The total sales shall include all sales from each account manager, doesn't matter if he/she is responsible for that account or not.

Could you elaborate? Perhaps include an excel showing how you calculate the 6.3 million or include a better explanation in the qvw.

Matt