Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
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!
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?
Never tried this before but it worked!
Amazing and easy Thanks