Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ShaunGinCT
Contributor
Contributor

Ignoring Filter

Hi, I'm new to this so please forgive the question:
I have the following expression using set analysis =Only({1<S_START_DATE = {'$(=MonthEnd(Max(Addmonths(S_START_DATE,-1))))'}>} STATUS_VALIDATED) and I have a filter called BP_Business_Partner that I would like to exclude from the calculation, I've seen options for sum, however cannot get this to work on the '=Only()' statement.

Thanks

S

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

You are already excluding all filters currenlty. because of the 1.

if you want to exclude just BP_Business_Partner change to soemthing like below (removed 1 and added the part in bold)

 

Only({<BP_Business_Partner=,S_START_DATE = {'$(=MonthEnd(Max(Addmonths(S_START_DATE,-1))))'}>} STATUS_VALIDATED)