topic Trend Chart in QlikView

Trend Chart

manideep78 — Tue, 18 Feb 2014 08:43:27 GMT

Dear Community.

I need to develop the below chart. Can you please let me know how can I proceed for this? How can I get those Vertical Lines?

Thanks a ton in advance

Thanks & Regards

Manideep

Re: Trend Chart

SreeniJD — Tue, 18 Feb 2014 08:48:56 GMT

Hi Manideep,

With the combo chart we can try this report, if you can share me the sample data, I might help you...

Sreeni

Re: Trend Chart

sujeetsingh — Tue, 18 Feb 2014 08:48:57 GMT

manideep,

You need to analyse the data for this trend chart

--cpp and cp can be implemented by using reference line

--may you should use Off set for expressions

Re: Trend Chart

manideep78 — Tue, 18 Feb 2014 09:02:19 GMT

Hi jaladurgam sreenivasulu

How Can I take two dimesions (Month and LT/ST) same as above. If I take two dimensions the second one is coming as legend.

Re: Trend Chart

Tue, 18 Feb 2014 09:27:04 GMT

That vertical line chart looks like a box plot. There is a chart wizard to create this

Re: Trend Chart

DavidFoster1 — Tue, 18 Feb 2014 10:38:33 GMT

Looks like a line chart with 4 expressions and a reference line for the '0.78'.

I would suggest that The CpK 'line' has error lines on it to represent the box plot style.

Re: Trend Chart

manideep78 — Wed, 19 Feb 2014 03:38:50 GMT

Hi David Foster,

Your answer is similar to what I need. Here The vertical lines are connecting lines between Max(Cpk) and Min(Cpk) per month. and also How Can I get LT\ST as second dimension under the Month? Can you please help in achieving this?

Thanks & Regards

Manideep

Re: Trend Chart

vikasmahajan — Wed, 19 Feb 2014 03:41:27 GMT

PFA sample

Vikas

Re: Trend Chart

manideep78 — Wed, 19 Feb 2014 04:00:27 GMT

Hi Vikas Mahajan

Instead of bars I would like to plot vertical lines that connects between Min values and Max values Per month. How can I do this?

Re: Re: Trend Chart

vikasmahajan — Wed, 19 Feb 2014 04:51:30 GMT

PFA

Vikas

Re: Trend Chart

manideep78 — Wed, 19 Feb 2014 08:21:31 GMT

Thanks for the answer. But My requirement is different. Here for every ID dimension, I will have minimum and maximum values. I need a vertical line for those Min and Max value for every ID.

Re: Trend Chart

manideep78 — Wed, 19 Feb 2014 08:33:55 GMT

Hi PFA.

In that there is one Max and Min for every ID. SO I need vertical Line connecting those to points.

How can I achieve this?

Re: Trend Chart

manideep78 — Wed, 19 Feb 2014 11:41:07 GMT

Anyone please?

Re: Trend Chart

vikasmahajan — Wed, 19 Feb 2014 11:53:11 GMT

Not Sure Please check Hope this will work for you.

Vikas

Re: Trend Chart

manideep78 — Wed, 19 Feb 2014 12:22:12 GMT

Thanks a lot for the quick response Vikas. But I need a Straight vertical line between Min value and Max value. Is there any way we do this?

Re: Trend Chart

DavidFoster1 — Wed, 19 Feb 2014 13:03:29 GMT

You can add error bars to an expression quite easily.

1) Create the expression

2) Tick the 'has error bars' option

3) If you expand the expression (where you normally set things like text colour) you will now see 3 extra settings for error above, error below and error symmetric. You just need to add in your expressions for the vertical bars in these settings.

Hope that helps