Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
data_RN
Creator
Creator

Ignore filtering in set formula with variable

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!

Labels (1)
1 Solution

Accepted Solutions
data_RN
Creator
Creator
Author

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 🙂

View solution in original post

4 Replies
BrunPierre
Partner - Master
Partner - Master

Hi, like this?

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

data_RN
Creator
Creator
Author

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

BrunPierre
Partner - Master
Partner - Master

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
Creator
Creator
Author

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 🙂