Select Excluded in Set Analysis

[RichardLinderman]

I've currently got the following function:

Sum({< ProductPage = {"Air"}, Datefield = {$(=Max(Datefield))}>}[Fare Amount])

I want to add an area to the function based on a field named "Account Code" so that, if I selected a particular "Account Code" value, it would display the results excluding the value I selected. I know this can kinda be done out of edit mode, but I need it in the function itself.

[Antoine04]

Hello,

What about something like :

Sum({<

ProductPage = {"Air"},

Datefield = {$(=Max(Datefield))},

[Account Code]-={'$(=Concat(Distinct [Account Code],','))'}

>}[Fare Amount])

Regards,

Antoine

[marksouzacosta · Accepted solution]

You can also try using E():

Sum({<

ProductPage = {"Air"},

Datefield = {$(=Max(Datefield))},

[Account Code] = E([Account Code])

>} [Fare Amount])

More about E Set Function in the link below:
Set modifiers using set functions | Qlik Sense on Windows Help