Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
rittermd
Master
Master

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?


0 Replies