topic Re: Ignore filtering in set formula with variable in QlikView

Ignore filtering in set formula with variable

data_RN — Sat, 04 Mar 2023 14:25:10 GMT

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 — Mon, 06 Mar 2023 22:18:32 GMT

Hi, like this?

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

data_RN — Sun, 05 Mar 2023 12:40:40 GMT

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

BrunPierre — Sun, 05 Mar 2023 14:00:17 GMT

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 — Mon, 06 Mar 2023 21:08:26 GMT

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 🙂