topic need to change calculated dimension to reduce complexity in App Development https://community.qlik.com/t5/App-Development/need-to-change-calculated-dimension-to-reduce-complexity/m-p/1439795#M34776 <HTML><HEAD></HEAD><BODY><P>Hi, I have two dimension and two expressions.</P><P>The expressions are: </P><P>1. Sum of sales</P><P>2. Sum of total sales</P><P></P><P>And dimensions are:</P><P>1. Sales Person Name</P><P>2. Global Business Unit</P><P></P><P>I need to create straight table to display this data and I need to display top 5 Sales Person name based on sum of sales.</P><P></P><P>I am using aggr and rank function to create calculated dimension.</P><P>I have created two calculated dimension. One for Sales person name and another for Global Business Unit.</P><P>Now my complexity is increased which I do not want.</P><P>I am trying to use direct field names in dimension and restricting the values using Dimension limit tab. But the problem is for Global Business Unit field. Since I am restricting it also but I am getting 5 values for each Sales Person Name.</P><P>How can I get the top global business unit name for each sales person name.</P><P></P><P></P><P>Thanks for your help.</P></BODY></HTML> Tue, 05 Sep 2017 14:46:59 GMT musketeers 2017-09-05T14:46:59Z need to change calculated dimension to reduce complexity https://community.qlik.com/t5/App-Development/need-to-change-calculated-dimension-to-reduce-complexity/m-p/1439795#M34776 <HTML><HEAD></HEAD><BODY><P>Hi, I have two dimension and two expressions.</P><P>The expressions are: </P><P>1. Sum of sales</P><P>2. Sum of total sales</P><P></P><P>And dimensions are:</P><P>1. Sales Person Name</P><P>2. Global Business Unit</P><P></P><P>I need to create straight table to display this data and I need to display top 5 Sales Person name based on sum of sales.</P><P></P><P>I am using aggr and rank function to create calculated dimension.</P><P>I have created two calculated dimension. One for Sales person name and another for Global Business Unit.</P><P>Now my complexity is increased which I do not want.</P><P>I am trying to use direct field names in dimension and restricting the values using Dimension limit tab. But the problem is for Global Business Unit field. Since I am restricting it also but I am getting 5 values for each Sales Person Name.</P><P>How can I get the top global business unit name for each sales person name.</P><P></P><P></P><P>Thanks for your help.</P></BODY></HTML> Tue, 05 Sep 2017 14:46:59 GMT https://community.qlik.com/t5/App-Development/need-to-change-calculated-dimension-to-reduce-complexity/m-p/1439795#M34776 musketeers 2017-09-05T14:46:59Z Re: need to change calculated dimension to reduce complexity https://community.qlik.com/t5/App-Development/need-to-change-calculated-dimension-to-reduce-complexity/m-p/1439796#M34777 <HTML><HEAD></HEAD><BODY><P>It might help to look at a sample... can you share a sample or some raw data to explore this?</P></BODY></HTML> Tue, 05 Sep 2017 16:54:10 GMT https://community.qlik.com/t5/App-Development/need-to-change-calculated-dimension-to-reduce-complexity/m-p/1439796#M34777 sunny_talwar 2017-09-05T16:54:10Z