Difficulties plotting a line

[Anonymous]

Hi QlikView-People,

i have a line chart.The dimenions is "product" and the functions are the dimensions "start period", "end period".

I want to show for the dimension "product" the time duration on the market. I know the start and end of the duration (saved in the two dimensions "start period", "end period") for each "product" (dimension). For each product i want QlikView to draw a line, which starts in "start period" and ends in "end period". Unfortunatly i havent been able to figure out how to do this so far. The problem ist that the "start period" and "end period" are dimensions and if i plot them as lines a line is only drawn within the dimension "start period"/"end period" from product to product.

To have an idea of the problem, here a screenshot of it :

Does anybody have an idea how to fix that problem?

Best regards

Mila

[christian77]

Hi:

I've done this before. Example attached. Gant diagram like...

here is an example. you´re gonna have to work out the dates, since I don´t have more time.

It´s just an idea.

I hope it helps.

[Anonymous]

Thats an nice idea. Unfortunatly it doesnt work in my case for the following reasons:

I want the duration started at the start period and ended at the end period, which is not the case in your example.

In your example i only get the duration which is not linked to the real timestamp.

Do you know how to fix that?

Best regards

Franzi

[christian77]

Yeah! working out the dates, time formats and all that. Work it out. It'll work.

[Anonymous]

Well I tried, the result is shown in the same dateformat as the start and end period. The date of the resulting duration seems to be nonsense. In your example the dates are in the 2011 and the result enddate-startdate is  in the 1900.

I tried several formats for the duration, but nothing seemed to work.

[kaushiknsolanki]

Hi,

   Have a look at the few more example on gantt chart.

   Hope this will help you.

Regards,

Kaushik Solanki

[christian77]

Great! That was the idea.

[Anonymous]

Alright, I have figured the trick out. But I am still havin problems, because i can count the duration only as months.

How can i inform QlikView that the duration is meant as month and not as days.

Many thanks.

Mila