Sum sales if no Client

[Anonymous]

Hi Guys

I have an issue I want to sum all  sales but want it to stay the same unless they select year or month but if they select a client the client sales come up

I want, if they select a client the sales not to change so it gives total for all clients every time a client is selected

This is because one field shows total but cannot get this to work

[Anonymous · Accepted solution]

Try adding this to your set analysis:

Client=

If your exp = sum(Sales)

Then your exp = sum({<Client=>}Sales)

This will ignore selection on the client

Hope this helps!

[sunny_talwar]

If what qlikdeez‌ provided doesn't work, would you be able to provide more details as to what you expression is and what you are trying to achieve with it?

[Anonymous]

Never tried this before but it worked!

Amazing and easy Thanks