topic Re: Line chart - dots only, hide lines in QlikView

Line chart - dots only, hide lines

Tue, 23 Jun 2015 14:48:26 GMT

Hi,

I need to show dots only, no lines. Any ideas?

Re: Line chart - dots only, hide lines

Tue, 23 Jun 2015 14:57:30 GMT

Hi, This option is available on the Expression tab of the Chart Properties.

Goto Chart Properties --> Expressions --> In the middle there loat of options. Un check the Line & Check the Symbol & Select Dots

Re: Line chart - dots only, hide lines

buzzy996 — Tue, 23 Jun 2015 14:58:51 GMT

see tis,

Re: Line chart - dots only, hide lines

Tue, 23 Jun 2015 15:10:20 GMT

It works!

However is there a way to force the graph to always show dots?

When the observations are many the chart shows a line instead of dots.

When choosing Jan to Apr

Choosing jan to may

Re: Line chart - dots only, hide lines

buzzy996 — Tue, 23 Jun 2015 15:21:51 GMT

by unchecking tht line check box it won't show the line,what i believe!

Re: Line chart - dots only, hide lines

Tue, 23 Jun 2015 15:36:27 GMT

This Chart specific option. If you have multiple charts, you need turn this option to other chart as well.

Re: Line chart - dots only, hide lines

Wed, 24 Jun 2015 07:13:44 GMT

Hmm interesting, where do I change it?

Re: Line chart - dots only, hide lines

Wed, 24 Jun 2015 07:18:42 GMT

Hi Shiva,

this is what it looks like. Still shows a line if the observations are many enough

Regards,

Olle

Re: Line chart - dots only, hide lines

buzzy996 — Wed, 24 Jun 2015 08:06:07 GMT

is't possible to share ur app with less data?,then we will try to help here.

Re: Line chart - dots only, hide lines

jonathandienst — Wed, 24 Jun 2015 08:08:59 GMT

It will show a line if there are more than a certain number of data points regardless of these settings. I am not aware if a simple workaround exists.

Re: Line chart - dots only, hide lines

Wed, 24 Jun 2015 08:22:01 GMT

pls find attached.

Rgds,

Olle

Re: Line chart - dots only, hide lines

Wed, 24 Jun 2015 08:24:05 GMT

Could I work around this issue by using another chart type?

I would like it to look like the classical scatter chart in Excel but as you know it does not work the same way in QlikView...

Re: Line chart - dots only, hide lines

buzzy996 — Wed, 24 Jun 2015 08:46:47 GMT

PFA,SEE SHEET2..i feel this is best way we can show.

on ur first sheet some special properties are enabled already(look at number tab sheet1).