Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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