Bar chart that reflects date spans

Mon, 23 Jul 2012 19:17:09 GMT

I am having a difficult time figuring out how to do the following:

My data source contains a set of tickets that are given a creation date and completion date. Typically these dates wll all occur within the same month, but on occasion a ticket can span over several months.

I would like for my bar chart to reflect a value of 1, for each ticket, for each month that it spans.

Here is some sample data:

Ticket #	Create Date	Complete Date	Status
TK351	2/12/2012	6/4/2012	Complete
TK352	5/1/2012	5/2/2012	Complete
TK353	1/1/2012	-	In-Progress

Based on the above, I would like the chart to reflect that the ticket was "relevant" for the following months marked with an X:

(since the current month is July, I need an x in this month for TK353 since it is still in progress (no complete date has been entered))`

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

TK351

TK352

TK353

Using the above, I can show a crude ASCII bar chart showing how it would look:

				x
	x	x	x	x	x
x	x	x	x	x	x	x
Jan	Feb	Mar	Apr	May	Jun	Jul

The issue I have is that the data is not time-variant, meaning I don't get a record for each month when the ticket remains open during that month. I only have the one record like above reflecting the date span.

On the same note, when the ticket is complete, I would like for it to not display on the chart. For this I can read the value of "Status" as to whether or not I increment the bar chart by +1.

Thanks for the help...

Re: Bar chart that reflects date spans

Tue, 24 Jul 2012 10:50:11 GMT

check this:

Re: Bar chart that reflects date spans

Tue, 24 Jul 2012 16:19:08 GMT

Hi Pari,

Thank you for this example. It is definitely one way to approach the problem, but I find that it is restrictive in terms of how my end users can use the QV dashboard. Mainly, they need to be able to adjust the date dimensions like Month.

topic Re: Bar chart that reflects date spans in QlikView

Bar chart that reflects date spans

Re: Bar chart that reflects date spans

Re: Bar chart that reflects date spans