Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hello,
What about something like :
Sum({<
ProductPage = {"Air"},
Datefield = {$(=Max(Datefield))},
[Account Code]-={'$(=Concat(Distinct [Account Code],','))'}
>}[Fare Amount])
Regards,
Antoine
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