How to not take into account the current selections

[#1]

Hi,

I have a Qlikview bar chart with :

-dimension = Customer

-expresion =sum(Quantity shipped)

-expresion=sum(Quantity in order)

I can do selections by year, by month. So when I select a certain year, month I get the 'shipped' quantities and 'in order' for that specific year and month.

Now my problem is that I want to add a new expresion that will sum all my quantities 'in order' without taking into account the year and month selected.

Is this possible? How can I specify in my formula that the current selection for year and month must not be taken into account?

Thank you! 

[#2 · Accepted solution]

if you only want to exclude those dimensions you can do:

sum({<year=,month=    >}Quantity in order)

if you want to exclude all selection then this should do:

sum({1}Quantity in order)

[#3]

Hi,

I tried and it's working.

Thank you for your answer!