Calculated dimension with if condition

Tue, 04 Aug 2015 15:00:17 GMT

Hello!

I have a prob here.

I have a straight table with top employees with biggest values. A user can pick a number of months in the filter to see top employees.

What i need to achieve is: if the date of dismissal of employee is greater than max month picked in the filter than he will be in this list, if his date of dismissal in earlier than max month picked than this employee won't be included in the list.

I used the calculated dimension, but it's not working correctly :

=aggr(IF(Rank(IF(isNull(Dismissed) or num(Month(Dismissed))>=num(Max(Month(Month_Date))),Sum(Bench_Data)/$(vNoOfMonths)))<=10,Emp_name),Emp_name)

U can test the samle app attached to this post.

Any help will be appreciated.

topic Calculated dimension with if condition in QlikView

Calculated dimension with if condition