topic Re: Line chart axes in QlikView

Line chart axes

Thu, 17 Apr 2014 06:11:15 GMT

How do I make my line chart axes like the book ? Please see image -

Re: Line chart axes

rajat2392 — Thu, 17 Apr 2014 06:15:48 GMT

In chart properties, under Axes tab, check Minor Grid in Expression axes.

And in Scale section, set Static Min, Static Max, and Step as expression as Min(Expression), Max(Expression) and step what you want respectively.

Re: Line chart axes

its_anandrjs — Thu, 17 Apr 2014 06:17:06 GMT

From chart properties >> Expressions >> Display options

See the attached snap for that

From Circle to change it dot or auto

Re: Line chart axes

ariel_klien — Thu, 17 Apr 2014 06:18:03 GMT

Re: Line chart axes

Thu, 17 Apr 2014 06:31:02 GMT

I set the scale > static step = 50 > apply > ok. But my chart does not change. What is the mistake ?

Re: Line chart axes

Thu, 17 Apr 2014 06:32:11 GMT

Please read my question again. Its about the axes and not the dots on curves.

Re: Line chart axes

rajat2392 — Thu, 17 Apr 2014 06:32:40 GMT

Can you please attach your file?

Re: Line chart axes

Thu, 17 Apr 2014 06:39:39 GMT

if you want to have dots instead of circles : right click > properties> Expressions> select "dots" from the drop down next to the symbol check box

if you are talking about the amounts on the axes: right click > properties> Axes > uncheck "force 0"

hope this help... let me know if this is not the problem you are facing

Cheers

Re: Line chart axes

Thu, 17 Apr 2014 06:41:21 GMT

disregard the 1st point then

right click > properties> Axes > uncheck "force 0"

Re: Line chart axes

ramkrishna86 — Thu, 17 Apr 2014 06:46:49 GMT

Please set all three property Static Min, Static Max and Static Step together.

Or check if you have valid data to show in the chart.

if this not solve your problem please attach your QVW file.

Re: Line chart axes

ariel_klien — Thu, 17 Apr 2014 06:49:55 GMT

Re: Line chart axes

MK_QSL — Thu, 17 Apr 2014 07:01:43 GMT

Go to Axes Tab

and untick Forced 0 under expression axes

Under Scale

Tick Static Min and Static Max and write values either static as 0 and 1000 or dynamic

Min(Aggr(Count(Flights),Month))

and

Max(Aggr(Count(Flights),Month))

Re: Line chart axes

Thu, 17 Apr 2014 16:58:57 GMT

That gives me - no data to display. Btw, why should I have to set a static max ? Shouldn't the software just draw a line after every 50 steps ?

Re: Line chart axes

Thu, 17 Apr 2014 17:03:46 GMT

That made some difference. I only saw 800, 900. To see more data points, I increased the chart size and it became like the one shown in the book. But, when I maximized the chart, it shows a step every 5 points even after putting static step = 50. So, step size depends on the size of your chart ???

Re: Line chart axes

Fri, 18 Apr 2014 12:58:55 GMT

is your "split axes" check box checked?

Re: Line chart axes

Fri, 18 Apr 2014 13:01:05 GMT

if it is uncheck it... sorry for the delay btw