topic Exclude values from a dimension in a chart object in QlikView https://community.qlik.com/t5/QlikView/Exclude-values-from-a-dimension-in-a-chart-object/m-p/193247#M54588 <HTML><HEAD></HEAD><BODY><P>Just figured it out. In the Axes tab of the Chart Properties box, I changed the Dimension Axis to Continuous. This allowed me to customise the Scale settings. So I entered Static Min = 7, Static Max = 23, Static Step = 1.</P></BODY></HTML> Thu, 25 Mar 2010 11:40:40 GMT 2010-03-25T11:40:40Z Exclude values from a dimension in a chart object https://community.qlik.com/t5/QlikView/Exclude-values-from-a-dimension-in-a-chart-object/m-p/193245#M54586 <HTML><HEAD></HEAD><BODY><P>I have a line chart with a dimension called BookingHour (with values 1 - 23) and an expression called Sum(Tickets). Is there a way to exclude certain values from BookingHour? I would like to only display values 7 - 23 in the chart.</P><P>Thank you.</P></BODY></HTML> Thu, 25 Mar 2010 11:23:59 GMT https://community.qlik.com/t5/QlikView/Exclude-values-from-a-dimension-in-a-chart-object/m-p/193245#M54586 2010-03-25T11:23:59Z Exclude values from a dimension in a chart object https://community.qlik.com/t5/QlikView/Exclude-values-from-a-dimension-in-a-chart-object/m-p/193246#M54587 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">sum(if(BookingHour&gt;=7 and BookingHour&lt;=23,Tickets))</PRE></BLOCKQUOTE><BR /><BR /> <P>Best regards,</P><P>Konstantins</P></BODY></HTML> Thu, 25 Mar 2010 11:39:23 GMT https://community.qlik.com/t5/QlikView/Exclude-values-from-a-dimension-in-a-chart-object/m-p/193246#M54587 skaredovs 2010-03-25T11:39:23Z Exclude values from a dimension in a chart object https://community.qlik.com/t5/QlikView/Exclude-values-from-a-dimension-in-a-chart-object/m-p/193247#M54588 <HTML><HEAD></HEAD><BODY><P>Just figured it out. In the Axes tab of the Chart Properties box, I changed the Dimension Axis to Continuous. This allowed me to customise the Scale settings. So I entered Static Min = 7, Static Max = 23, Static Step = 1.</P></BODY></HTML> Thu, 25 Mar 2010 11:40:40 GMT https://community.qlik.com/t5/QlikView/Exclude-values-from-a-dimension-in-a-chart-object/m-p/193247#M54588 2010-03-25T11:40:40Z Exclude values from a dimension in a chart object https://community.qlik.com/t5/QlikView/Exclude-values-from-a-dimension-in-a-chart-object/m-p/193248#M54589 <HTML><HEAD></HEAD><BODY><P>Hi Konstantins,</P><P>I just tried your suggestion and it also works. Actually, I prefer your line of code over changing the Chart Properties as I mentioned earlier. Thanks very much for your quick reply!!!</P><P></P></BODY></HTML> Thu, 25 Mar 2010 11:45:39 GMT https://community.qlik.com/t5/QlikView/Exclude-values-from-a-dimension-in-a-chart-object/m-p/193248#M54589 2010-03-25T11:45:39Z