topic Bar/Symbol Chart Possibilities in QlikView

Bar/Symbol Chart Possibilities

Tue, 11 Aug 2015 12:46:17 GMT

Hey All,

I am trying to create a Milestone/Gantt Chart visualization and I was wondering if anyone knows if the following can be performed using a single chart?

currently I am producing this by overlaying two charts, one for the bar one for the symbols - works well except when you try to scroll, only the top image scrolls disassociating the data.

when I try to put the same info into a line bar chart I get the following:

any ideas would be greatly appreciated

Thanks,

Vince

Re: Bar/Symbol Chart Possibilities

Tue, 11 Aug 2015 12:54:02 GMT

will you provide the sample data

it may possible with bar offset option in expressions

Re: Bar/Symbol Chart Possibilities

jonathandienst — Tue, 11 Aug 2015 12:58:19 GMT

Can you not do this with combo chart with symbols for expressions > 2 and select the horizontal style?

Re: Bar/Symbol Chart Possibilities

marcus_sommer — Tue, 11 Aug 2015 13:01:27 GMT

Maybe you could use a combi-chart with bars and points (instead of lines). Maybe also this posting is helpful: Recipe for a Gantt chart

- Marcus

Re: Bar/Symbol Chart Possibilities

Tue, 11 Aug 2015 13:03:28 GMT

when wanting to use multiple symbols in a chart, especially when trying to build a milestone chart, a combo chart is the way to go - it will allow differnt symbols for different expressions

Re: Bar/Symbol Chart Possibilities

Tue, 11 Aug 2015 13:16:05 GMT

Here is some sample data:

SwimLane	DurationBar	BarOffSet	Milestone	MilestoneDate
SwimLane 1	650.375	11/3/2009	Milestone1	8/15/2011
SwimLane 1	650.375	11/3/2009	Milestone2	11/3/2009
SwimLane 2	593	7/15/2011	Milestone1	2/27/2013
SwimLane 2	593	7/15/2011	Milestone2	7/15/2011
SwimLane 3	189	8/9/2012	Milestone3	12/8/2011
SwimLane 3	189	8/9/2012	Milestone1	8/22/2013
SwimLane 3	189	8/9/2012	Milestone4	1/31/2013
SwimLane 3	189	8/9/2012	Milestone2	8/9/2012
SwimLane 3	189	8/9/2012	Milestone5	2/14/2013
SwimLane 3	189	8/9/2012	Milestone6	10/4/2012
SwimLane 3	189	8/9/2012	Milestone7	12/20/2012
SwimLane 4	1131.625	12/29/2010	Milestone1	2/3/2014
SwimLane 4	1131.625	12/29/2010	Milestone2	12/29/2010
Swim Lane 5	790.625	4/3/2012	Milestone1	6/3/2014
Swim Lane 5	790.625	4/3/2012	Milestone2	4/3/2012
Swim Lane 5	790.625	4/3/2012	Milestone5	11/2/2012

The SwimLane is the different rows

The Duration Bar is the length of the bar

The BarOffset is where the bar Begins

The Milestone are the different symbols

The MilestoneDate is the placement of the symbols

Re: Bar/Symbol Chart Possibilities

Tue, 11 Aug 2015 13:18:14 GMT

This is what I am trying to do with the second image I pasted.

The thing is the Milestones are variable ~100 different ones, would I need to create an expression for each name?

Currently I have the swimlane name and milestones both as dimensions and milestone date as the expression.

Re: Bar/Symbol Chart Possibilities

Tue, 11 Aug 2015 13:20:15 GMT

Thanks for the link - I looked at it, but I am currently able to have the Gantt part work, it does not go into how to build in milestones as well.

Re: Bar/Symbol Chart Possibilities

Anonymous — Tue, 11 Aug 2015 13:27:59 GMT

hi vincent,

you are going in right direction using bar chart,please classify each milestone/swimline as an expression each

Regards

Neetha

Re: Bar/Symbol Chart Possibilities

Tue, 11 Aug 2015 13:56:47 GMT

So I would need to make an expression for each potential (~100 different milestones) - wouldnt't that kill performance?

Re: Bar/Symbol Chart Possibilities

Anonymous — Tue, 11 Aug 2015 14:07:34 GMT

group the data based on symbols you are using in sample chart you want to achieve.

as performance wise,maybe only one expression with if else statement with one symbol only and different colours for each milestone.

Re: Bar/Symbol Chart Possibilities

baliyan_vinay — Tue, 04 Feb 2020 03:20:23 GMT

Hello Jonty,

Came across the post and I have a similar case. For the second expression, I have added a symbol the expression but it does not appear on the bar of first expression and appears rather below it.

How can it be on the bar of the first expression please? Thank you.