topic Re: Limit values on Y-Axis in QlikView

Limit values on Y-Axis

Wed, 15 Aug 2012 16:14:26 GMT

I need to limit the number of values that are displayed on my y-axis to 10. Right now I am showing too many values. How do I limit the number? I know I have to create a formula in Static Step but I don't know what that formula would be.

Thanks.

Re: Limit values on Y-Axis

swuehl — Wed, 15 Aug 2012 16:40:03 GMT

If you know that your range of values is always like that, you can just input a fixed, magic number, no need for a complex expression, mayne try just inputting

500000000

as static step.

Re: Limit values on Y-Axis

shree909 — Wed, 15 Aug 2012 16:53:58 GMT

Hi go the chart properties and there u find the option axes

chart-->properties-->axes--scale

there u have static min, static max and step size there u provide the values

the the axes would be static..

so static max =10

static min=0

step size =1

hope this helps

Re: Limit values on Y-Axis

Wed, 15 Aug 2012 17:22:57 GMT

The Y-axis changes based on the filters that are chosen so simply entering 500000 in the Static Step will not work.

Re: Limit values on Y-Axis

shree909 — Wed, 15 Aug 2012 17:27:31 GMT

i think u need to make both the x and y axis static then no matter the values get changes but the axis values will be same..

Re: Limit values on Y-Axis

Wed, 15 Aug 2012 18:55:56 GMT

I would however the y-axis could be Thousands, Millions or even Billions of $

Re: Limit values on Y-Axis

shree909 — Wed, 15 Aug 2012 19:50:15 GMT

i think you can convert into either billions or millions and show the result.

Re: Limit values on Y-Axis

Thu, 16 Aug 2012 10:47:19 GMT

Could you please attach your application?

Re: Limit values on Y-Axis

Tue, 08 Jan 2013 20:52:29 GMT

That is so awesome. Never saw that before.