Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Honored Contributor

Ignore calculated Dimension in Set Analysis

I have a Dimension that is based on an expression to limit the values that are displayed (2012-2017):

=if(num([HireDate.autoCalendar.Year])> $(V5YearAgo), [HireDate.autoCalendar.Year])

In my set analysis expression I want to ignore the above choice when calculating 

I tried [HireDate.autoCalendar.Year]= and that doesn't work.

Count( {$<StatusText={'Active'},[HireDate.autoCalendar.Year]=>} Distinct  EmployeeID)

Is there a way to have the set analysis ignore the calculated dimension?

Community Browser