Ignore filtering in set formula with variable

[data_RN]

Hello Awesome folks, 

I am working with a max formula where I want to keep the max value regardless of the filters applied.

max( Total aggr($(v_NPV),ID))

I have found that {1} is supposed to do the trick, but I can not figure out how to make it work.

Any tips?

Thanks as always!

[BrunPierre]

Hi, like this?

Max({1} Total Aggr({1} $(v_NPV), ID))

[data_RN]

Well, it works if I try to filter by ID, but if I apply any other filter, it becomes filtered 😕

[BrunPierre]

The "TOTAL" keyword instructs Qlik to ignore all dimension values. The dimensions required to interact with the expression must be specified.

Max(TOTAL<DIM1,DIM2,DIM3>Aggr($(v_NPV),ID))

[data_RN · Accepted solution]

Thanks @BrunPierre !

With a fresh head, I found that it works with the TOTAL in place:

max( {1}Total aggr({1}$(v_NPV),ID))

Thanks so much for getting me there 🙂