# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for
Did you mean:  Employee

## Need to ignore one filter

I can not figure out where to place the set analysis in this expression to ignore a single filter (FISCAL_YEAR).  It currently has no Set Analysis and every place I have tried to put it throws and error.

{<FISCAL_YEAR=>}

I'm not sure I can even do it since the expression is actually using this field.

='Total Realized Impact: ' & NUM(Sum (if(FISCAL_YEAR =If(num(Month(Now())) <= 6, Year(Now()) - 1, Year(Now())), MONTHLY_QUANTIFIED)), '\$ #,##0','.',',') &'
Total Target Impact: ' & NUM(Sum (if(FISCAL_YEAR = If(num(Month(Now())) <= 6, Year(Now()) - 1, Year(Now())), MONTHLY_TARGET)), '\$ #,##0','.',',')

Any guidance is greatly appreciated.

1 Solution

Accepted Solutions  Partner - Master III

change your expression to below

declare variable like so vYear = If(num(Month(Now())) <= 6, Year(Now()) - 1, Year(Now()) )

Sum ( {<FISCAL_YEAR ={"\$(=vYear)"}>} MONTHLY_QUANTIFIED)

2 Replies  Partner - Master III

change your expression to below

declare variable like so vYear = If(num(Month(Now())) <= 6, Year(Now()) - 1, Year(Now()) )

Sum ( {<FISCAL_YEAR ={"\$(=vYear)"}>} MONTHLY_QUANTIFIED)  Contributor III

I am not sure about the logic of the calculation but that's how you ignore filters - if you had a column, called 'FromDate' and you want to count IDs, ignoring any filters applied to it, then this will be the expression:

Count({<FromDate=>}ID)

My advice - build up the formula step by step so you can figure out where the error is coming from, it could be an extra bracket or the right number of brackets but in the wrong places. Tags
Community Browser