topic Re: Setting graph ranges in QlikView https://community.qlik.com/t5/QlikView/Setting-graph-ranges/m-p/375259#M139795 <HTML><HEAD></HEAD><BODY><P>try an IF condition.</P><P>IF(avg(revenue)&gt;10,avg(revenue))</P><P>this will only show the average revenue, if its hihher than 10</P></BODY></HTML> Thu, 05 Jul 2012 09:05:31 GMT 2012-07-05T09:05:31Z Setting graph ranges https://community.qlik.com/t5/QlikView/Setting-graph-ranges/m-p/375258#M139794 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am having trouble creating a graph that will only display values about a certain range. I have a Company list and there avg rev.&nbsp; ave rev is an expression. I only want to display ave revs above a certain value on my graph.&nbsp;&nbsp; How can I do this? since it is am expression I cant write a dimension that will hide the zeros, or can?</P><P></P><P>Thank you</P></BODY></HTML> Thu, 29 Mar 2012 08:46:33 GMT https://community.qlik.com/t5/QlikView/Setting-graph-ranges/m-p/375258#M139794 2012-03-29T08:46:33Z Re: Setting graph ranges https://community.qlik.com/t5/QlikView/Setting-graph-ranges/m-p/375259#M139795 <HTML><HEAD></HEAD><BODY><P>try an IF condition.</P><P>IF(avg(revenue)&gt;10,avg(revenue))</P><P>this will only show the average revenue, if its hihher than 10</P></BODY></HTML> Thu, 05 Jul 2012 09:05:31 GMT https://community.qlik.com/t5/QlikView/Setting-graph-ranges/m-p/375259#M139795 2012-07-05T09:05:31Z