Limit length of bar - Qlik Community

Anonymous · ‎2014-07-01

Hi

I want to show the year on year variance of sales in a bar chart. If an item only sold a very small amount last year potentially there is a very high variance (thousands of %). This makes the bar chart look stupid as there is no way easily seeing the variances. Is there any way to limit the length of a bar to a certain amount when the variance is huge?

Thanks

jonathandienst · ‎2014-07-01

Hi

RangeMin(100, ... variance calculation ...)

will limit the value to 100 or less.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

rbecher · ‎2014-07-01

RangeMin?

Astrato.io Head of R&D

jonathandienst · ‎2014-07-01

Ralf

That was a typo - fixed now.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein