topic Re: Sum sales if no Client in QlikView

Sum sales if no Client

Anonymous — Thu, 05 Jan 2017 12:52:46 GMT

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

Re: Sum sales if no Client

Anonymous — Thu, 05 Jan 2017 12:57:48 GMT

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!

Re: Sum sales if no Client

sunny_talwar — Thu, 05 Jan 2017 13:00:52 GMT

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?

Re: Sum sales if no Client

Anonymous — Thu, 05 Jan 2017 13:18:55 GMT

Never tried this before but it worked!

Amazing and easy Thanks