topic Re: Calculated dimension with conditions in QlikView https://community.qlik.com/t5/QlikView/Calculated-dimension-with-conditions/m-p/918199#M318323 <HTML><HEAD></HEAD><BODY><P>Guys, any ideas?????</P></BODY></HTML> Wed, 29 Jul 2015 13:22:25 GMT 2015-07-29T13:22:25Z Calculated dimension with conditions https://community.qlik.com/t5/QlikView/Calculated-dimension-with-conditions/m-p/918198#M318322 <HTML><HEAD></HEAD><BODY><P>Hello,guys!</P><P></P><P>I got stucked with calculated dimension in straight table.</P><P></P><P>First, let me explain the main idea of this table. This table shows top 10 employees with biggest average value named Bench_data.</P><P>I created a calculated dimension: =aggr(IF(Rank(IF(Month_name&gt;=(vCurMonth),Sum(Bench_Data*Forecast),Sum(Bench_Data)))&lt;=10 ,Emp_name),Emp_name)</P><P></P><P>As you see I have a condition of calculation depending on the period.</P><P></P><P>I also have an expression like :IF(Month_name&gt;=(vCurMonth),AVG(Bench_Data*Forecast),AVG(Bench_Data))</P><P></P><P>My management wants to see the average of values for a distinct period and they pick several months in the filter.</P><P></P><P>What I want now is to add the condition, if the dismissed date of employee is &gt; than the max month picked in the filter, this employee won't be shown in the table.</P><P></P><P>But I don't know how to do it.</P><P></P><P>Would be thankful for any help!</P><P></P><P>Sample app is attached</P></BODY></HTML> Tue, 28 Jul 2015 14:37:56 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-conditions/m-p/918198#M318322 2015-07-28T14:37:56Z Re: Calculated dimension with conditions https://community.qlik.com/t5/QlikView/Calculated-dimension-with-conditions/m-p/918199#M318323 <HTML><HEAD></HEAD><BODY><P>Guys, any ideas?????</P></BODY></HTML> Wed, 29 Jul 2015 13:22:25 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-conditions/m-p/918199#M318323 2015-07-29T13:22:25Z