topic Re: Trend Chart in QlikView

Trend Chart

jagannalla — Mon, 02 Jul 2012 09:04:50 GMT

Hello,

I want to devleop a chart as shown below. How can achive this? Please share your ideas.

Re: Trend Chart

Anonymous — Mon, 02 Jul 2012 09:07:30 GMT

Combo chart where the vertical lines are really thin bars using bar offset to space them accordingly would be my suggestion.

Re: Trend Chart

jagannalla — Mon, 02 Jul 2012 09:29:55 GMT

Here i'm attaching sample file. Please can you check and tell me how can we get vertical lines for each month wise.

Re: Trend Chart

Or — Mon, 02 Jul 2012 13:00:57 GMT

I don't think there's any way to achieve exactly what you're after - as far as I know, vertical lines aren't available in QlikView, and you can't control the bar width directly in a combo chart.

I've set up essentially the same thing using bars (maximum cluster space to make them as thin as possible) - that's probably the best you can do out of the box. File attached.

As an aside - your chart looks an awful lot like a box plot. You might want to have a look at the Box Plot Wizard to see if it fits what you need.

Re: Trend Chart

jagannalla — Tue, 03 Jul 2012 08:53:31 GMT

How you have developed Second expression i.e verticalLine. I mean how you moved bars upside. How it is representing?

Re: Trend Chart

Or — Tue, 03 Jul 2012 11:59:50 GMT

Open the expression - it's in the Bar Offset setting.