Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
kumarkp412
Contributor II

MultiLine Chart

Hi friends,

I am trying to create the multi-line chart as three line.In this two lines will tell comparison of two lines as continuous and third line should show the difference between two data points as discrete.Here I am able to create the two lines in the chart but not able to create the third line.

For your reference, I have given sample chart created in paint.

Need to make this in QlikView.I was structured in creating the third line. Can one helo me.

multilinechart.png

Any ideas to make this chart.

Thanks in Advance

Kumar KVP

1 Solution

Accepted Solutions
veidlburkhard
Contributor III

Re: MultiLine Chart

Sorry, Kumar,

seems I was kind of blocked in my head. But now I understand what you want.

DegeneratedBoxPlot.jpg

See the picture above. This was generated by using a kind of a degenerated box plot in order to create the vertical lines in your chart.
If this is what you want, go to the expression tab add an empty expression as box plot. Enter as expression for bottom, top and middle: Column(2) as expression do this also for lower whisker. For upper whisker enter : Sum(Value1) - Sum(Value1)*0.05 as expression. Also add a new expression Sum(Value1) - Sum(Value1)*0.05 which you declare as Symbol, Triangles (down), Another expression: Column(2) as Symbol, Triangles (up).

That's all.

See the below picture for details:


DegeneratedBoxPlot2.jpg



Hope this helps

Burkhard

9 Replies
veidlburkhard
Contributor III

Re: MultiLine Chart

Hi Kumar,

add a third expression like this: Column(1) - Column(2).

This will give you the difference line.

Hope this helps

Burkhard

gautik92
Valued Contributor III

Re: MultiLine Chart

Column(1)-Column(2) will do

kumarkp412
Contributor II

Re: MultiLine Chart

Hi Burkhard,

Thanks for your reply,

By using this expression I will get the difference but I need to represent the line as a vertical line.

How can I build the vertical line as arrow I shown  in image?

Any ideas to build the line.

Thanks

Kumar KVP

kumarkp412
Contributor II

Re: MultiLine Chart

Hi Gowtham,

Thanks for your reply ,

By using this we can get the difference value but how we will represent the value in a vertical line. Any idea.

Thanks

Kumar KVP

veidlburkhard
Contributor III

Re: MultiLine Chart

Hi Kumar,

if you want a vertical line, go to the general tab, switch from line chart to combo chart. Then go to the expression tab and mark the Bar check box with your third expression. With this the difference values are represented as vertical bars.

Frankly speaking I do not understand your issue with the arrow. In your picture it is placed horizontally, but your question is for a vertical arrow!?!

Could you please explain this issue again?

Burkhard

Re: MultiLine Chart

Like this

Exp1-above(exp1)

Or else required Application

- Anil Chowdary

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kumarkp412
Contributor II

Re: MultiLine Chart

Hi Burkhand,

My issue is i need to represent the third as vertical line in below attachement.

I will explain you,

Introduction:

In the line chart, I shown in the image contains three line right with x-axis as names(A,B,C) and Y-axis as values(0 to 300) ,in that  two lines are horizontal lines and one is a vertical line as arrow style.

Creating lines by default  :

Two horizontal lines are coming by using expression as sum(sales) as sales and sum(Qty) as Quantity

Another line as the difference between two lines i.e Quantity-sales as Diff.

To represent these line in the line chart sales and Quantity as horizontal lines as coming default line chart with two expressions and when I add the third expression it is also taking a horizontal line .

Requirement:

So now I need to represent the third as vertical line style as  arrow style like in the image .

Thanks in advance,

Kumar KVP

veidlburkhard
Contributor III

Re: MultiLine Chart

Sorry, Kumar,

seems I was kind of blocked in my head. But now I understand what you want.

DegeneratedBoxPlot.jpg

See the picture above. This was generated by using a kind of a degenerated box plot in order to create the vertical lines in your chart.
If this is what you want, go to the expression tab add an empty expression as box plot. Enter as expression for bottom, top and middle: Column(2) as expression do this also for lower whisker. For upper whisker enter : Sum(Value1) - Sum(Value1)*0.05 as expression. Also add a new expression Sum(Value1) - Sum(Value1)*0.05 which you declare as Symbol, Triangles (down), Another expression: Column(2) as Symbol, Triangles (up).

That's all.

See the below picture for details:


DegeneratedBoxPlot2.jpg



Hope this helps

Burkhard

kumarkp412
Contributor II

Re: MultiLine Chart

Hi Burkhard ,

Thank you so much for the valuable information on my chart and description.

Now I can able to show the line as I expected.

Thanks

Kumar KVP