topic Re: Limitting the legend values in QlikView https://community.qlik.com/t5/QlikView/Limitting-the-legend-values/m-p/1057155#M524240 <HTML><HEAD></HEAD><BODY><P>You can create a calculation condition for your chart (on general tab of chart properties), something like</P><P></P><P>=Count(Distinct Function) &lt;= 10</P><P></P><P>You can change the error message for the calculation condition unfullfilled also on general tab of chart properties to something like</P><P>='Please select less than 11 Function values'</P><P></P><P>If you create a list box for Function with style Windows checkboxes (on presentation tab), you can select / deselect single values. Note that no selections will still be considered 'all values'.</P></BODY></HTML> Wed, 17 Feb 2016 22:10:01 GMT swuehl 2016-02-17T22:10:01Z Limitting the legend values https://community.qlik.com/t5/QlikView/Limitting-the-legend-values/m-p/1057154#M524239 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a bar/line combo chart&nbsp; in which the dimensions are Function and Date .. a Functions can have values ranging from 5 - 25 , as it gets difficult for a user to read along 25 dimensions I want to limit the legend values to 10 , so say for example , user select a function values from the filter and that value has more 10 values I want to display a msg saying too many values , if its less than 10 then the values should be plotted on the chart and also is there a way that user can pick the values in legend like check boxes not dragging and selecting</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 17 Feb 2016 21:22:29 GMT https://community.qlik.com/t5/QlikView/Limitting-the-legend-values/m-p/1057154#M524239 Anonymous 2016-02-17T21:22:29Z Re: Limitting the legend values https://community.qlik.com/t5/QlikView/Limitting-the-legend-values/m-p/1057155#M524240 <HTML><HEAD></HEAD><BODY><P>You can create a calculation condition for your chart (on general tab of chart properties), something like</P><P></P><P>=Count(Distinct Function) &lt;= 10</P><P></P><P>You can change the error message for the calculation condition unfullfilled also on general tab of chart properties to something like</P><P>='Please select less than 11 Function values'</P><P></P><P>If you create a list box for Function with style Windows checkboxes (on presentation tab), you can select / deselect single values. Note that no selections will still be considered 'all values'.</P></BODY></HTML> Wed, 17 Feb 2016 22:10:01 GMT https://community.qlik.com/t5/QlikView/Limitting-the-legend-values/m-p/1057155#M524240 swuehl 2016-02-17T22:10:01Z