topic Re: Line Plot on Graph in QlikView

Line Plot on Graph

Wed, 30 Dec 2015 16:18:12 GMT

I am trying to connect the minimum and maximum plot points on this graph. I did it with a bar on a bar chart but it does not resize appropriately. Any idea on how just to make a line connect the two points?

Re: Line Plot on Graph

Clever_Anjos — Wed, 30 Dec 2015 16:25:49 GMT

Not sure what you want, would you mind posting an image of what you need?

Re: Line Plot on Graph

Wed, 30 Dec 2015 16:31:06 GMT

I posted the Qlik document. It has one example where the two data points are connected with a bar but I want a better solution if resized.

Re: Line Plot on Graph

Peter_Cammaert — Wed, 30 Dec 2015 16:31:20 GMT

In the left chart,

Disable/Delete the fourth expression.
Enter 'MinRad' in the expression for Bar Offset (expand the expression tree for MaxRad - MinRad)

I don't understand why you say that the current solution doesn't "resize correctly". What do you mean exactly?

Re: Line Plot on Graph

Wed, 30 Dec 2015 16:32:35 GMT

When you resize the chart the bar gets bigger. I want it to stay the same size. If I could some how connect the two dots that would be best.

Re: Line Plot on Graph

Clever_Anjos — Wed, 30 Dec 2015 16:37:26 GMT

Maybe using Error Bars?

Re: Line Plot on Graph

Wed, 30 Dec 2015 16:40:43 GMT

This is a possibility. Can we make them thicker? Can we make them appear behind the icons? Also how did you do it?

Re: Line Plot on Graph

Clever_Anjos — Wed, 30 Dec 2015 16:54:35 GMT

Go to Expressions and Select the 3rd one
Check "Has Errors Bars" it would enable Error Above and Error Below for "curr" expression
Go to Presentation Tab and "play" with "Error Bars" group
Not sure about how to make them appear behind the icons

I´ve attached my qvw, did you check it?

Re: Line Plot on Graph

Wed, 30 Dec 2015 17:03:53 GMT

How does it know how long to make the bars?

Re: Line Plot on Graph

Peter_Cammaert — Wed, 30 Dec 2015 17:06:22 GMT

You enter the correct expressions for each segment. (for example MaxRad - currr for the segment Above)

And I think that error bars will always be displayed on top of everything else.

Re: Line Plot on Graph

Wed, 30 Dec 2015 17:07:36 GMT

being on top is not a great idea.

Re: Line Plot on Graph

Peter_Cammaert — Wed, 30 Dec 2015 17:13:30 GMT

Another option is to create your own extension object. Allows you to configure and display the chart just like you want it.

Display types Box plot and Stock are too inflexible.

Re: Line Plot on Graph

Wed, 30 Dec 2015 17:14:32 GMT

Not too sure on how to do that. Can you help?

Re: Line Plot on Graph

Peter_Cammaert — Wed, 30 Dec 2015 17:18:51 GMT

If you don't know JavaScript, you better search for an existing extension (Qlik Market, Community, internet) to start with. Some programming is required. Maybe the D3 library offers what you need.

Re: Line Plot on Graph

Wed, 30 Dec 2015 17:22:23 GMT

Is there anyway just to add two lines to the graph just plotting. For example just offset the forumla y=mx+b from school??

Re: Line Plot on Graph

Peter_Cammaert — Wed, 30 Dec 2015 17:25:24 GMT

I think a scatter chart offers a way to connect three arbitrary points with a line. Not sure how to do it though

Re: Line Plot on Graph

Wed, 30 Dec 2015 17:30:09 GMT

Tell you what if I could just get control of the bar thickness everything would be perfect.

Re: Line Plot on Graph

Wed, 30 Dec 2015 18:32:18 GMT

Any other ideas? I am will to rebuild it. The only thing that has to stay is the data.