topic Issue -Line chart with 2 dimensions in QlikView https://community.qlik.com/t5/QlikView/Issue-Line-chart-with-2-dimensions/m-p/941515#M956342 <HTML><HEAD></HEAD><BODY><P>Using a line chart with 2 dimensions ,Primary dimension being the 'Date' figure and secondary dimension is a general field (Ex- Engineers).</P><P>Requirement is to restrict Engineers to 'TOP 10' among the entire data which in the chart is showing improper values.</P><P>Being the secondary dimension Different Top 10 values are coming for each Date value(Primary Dimension).</P><P>How to restrict this issue to only secondary dimension with top10 values in entire data and not on each date values. ??</P></BODY></HTML> Thu, 05 Nov 2015 07:08:54 GMT Pulkit_Thukral 2015-11-05T07:08:54Z Issue -Line chart with 2 dimensions https://community.qlik.com/t5/QlikView/Issue-Line-chart-with-2-dimensions/m-p/941515#M956342 <HTML><HEAD></HEAD><BODY><P>Using a line chart with 2 dimensions ,Primary dimension being the 'Date' figure and secondary dimension is a general field (Ex- Engineers).</P><P>Requirement is to restrict Engineers to 'TOP 10' among the entire data which in the chart is showing improper values.</P><P>Being the secondary dimension Different Top 10 values are coming for each Date value(Primary Dimension).</P><P>How to restrict this issue to only secondary dimension with top10 values in entire data and not on each date values. ??</P></BODY></HTML> Thu, 05 Nov 2015 07:08:54 GMT https://community.qlik.com/t5/QlikView/Issue-Line-chart-with-2-dimensions/m-p/941515#M956342 Pulkit_Thukral 2015-11-05T07:08:54Z Re: Issue -Line chart with 2 dimensions https://community.qlik.com/t5/QlikView/Issue-Line-chart-with-2-dimensions/m-p/941516#M956343 <HTML><HEAD></HEAD><BODY><P>Try using a calculated second dimension like</P><P></P><P>=aggr( if( Rank(Sum(Value),4,0)&lt;=10, Engineer), Engineer)</P><P></P><P>See also attached a sample QVW.</P><P></P><P>edit: Corrected a typo</P></BODY></HTML> Thu, 05 Nov 2015 16:44:36 GMT https://community.qlik.com/t5/QlikView/Issue-Line-chart-with-2-dimensions/m-p/941516#M956343 swuehl 2015-11-05T16:44:36Z Re: Issue -Line chart with 2 dimensions https://community.qlik.com/t5/QlikView/Issue-Line-chart-with-2-dimensions/m-p/941517#M956344 <HTML><HEAD></HEAD><BODY><P>Thanx for your help . <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>Its working</P></BODY></HTML> Thu, 05 Nov 2015 17:05:51 GMT https://community.qlik.com/t5/QlikView/Issue-Line-chart-with-2-dimensions/m-p/941517#M956344 Pulkit_Thukral 2015-11-05T17:05:51Z