topic Chart Display by Value in QlikView

Chart Display by Value

Thu, 29 Mar 2012 10:25:28 GMT

I have a chart with a company name as a dimension and average revenue as an expression. I want to make a graph that will only display companies that have an average revenue over a particular value. I cant seem to create any dimension that will separate the companies by value(if statements), and I cant find a way to only display certain expression values (because hide zeros only works for dimensions. Is there anyway for me to write a dimension that is based off the Avg Rev expression, OR is there anyway to only display certain expression values?

Thanks,

Re: Chart Display by Value

SunilChauhan — Thu, 29 Mar 2012 11:21:52 GMT

sort -> Y-axis-> check this

hope this helps

Re: Chart Display by Value

Thu, 29 Mar 2012 11:54:54 GMT

I have found the area under sort to enter an expression. What should my expression look like if I only want to display companies with a avg rev higher than 100?

Re: Chart Display by Value

Wed, 04 Apr 2012 14:02:43 GMT

Not sure what version you are using but in QV 11 this is easily done with Dimension limits.