topic Re: Line Chart Graphic should start at the value 50 in QlikView

Line Chart Graphic should start at the value 50

Wed, 31 Jul 2013 11:50:23 GMT

Hi,

I have a Linechart and it works. But my Graph shows me from 0 to 100. All the values are between 60 and 90 so all are small together. I would like to have the graph from 50 to 100. So that i dont see 20 because i dont have there some values and i would like to get the line chart bigger.

Hope you understand what i mean...

Re: Line Chart Graphic should start at the value 50

Tammy_Milsom — Wed, 31 Jul 2013 12:33:24 GMT

try using a calculated dimension:

if(Value>=50,Value)

or create an additional field where you only set the field when the value is 50 or above and use that as a dimension suppressing the null values.

Re: Line Chart Graphic should start at the value 50

Anonymous — Wed, 31 Jul 2013 12:47:00 GMT

Try using "Static Min" on the tab "Axes" in chart properties. Set it to 50.

Regards,

Michael

Re: Line Chart Graphic should start at the value 50

Wed, 31 Jul 2013 12:52:54 GMT

If i change static min it doesnt do something. But if i change static max i can set the max with no problem

Re: Line Chart Graphic should start at the value 50

Wed, 31 Jul 2013 12:56:38 GMT

Thanks Michael. It works with static min i just didnt saw/realiced that the "Forced 0" is checked....

After taking out that it works.

Re: Line Chart Graphic should start at the value 50

Wed, 31 Jul 2013 12:57:17 GMT

Maybe changing the "Static min" on the tab "Axes" and set it to 50 as Michael Solomovich indicates but also try to uncheck the check "show all values" in the dimension tab and check Supress zero values and suprees missing in the presentation tab.

Regards

Re: Line Chart Graphic should start at the value 50

Anonymous — Wed, 31 Jul 2013 12:58:20 GMT

Sorry, forgot to mention - you have also to uncheck "Forced 0" in the "Expression Axes" section (the top one0

Re: Line Chart Graphic should start at the value 50

Wed, 31 Jul 2013 13:01:52 GMT

Hi,

Try by unchecking "Forced 0".