Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

mila_ayuhara
New Contributor III

Difficulties plotting a line

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?

productduration_02.jpg


Best regards

Mila

7 Replies
christian77
Valued Contributor

Re: Difficulties plotting a line

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.

mila_ayuhara
New Contributor III

Re: Difficulties plotting a line

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
Valued Contributor

Re: Difficulties plotting a line

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

mila_ayuhara
New Contributor III

Difficulties plotting a line

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.

Re: Difficulties plotting a line

Hi,

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

   Hope this will help you.

Regards,

Kaushik Solanki

christian77
Valued Contributor

Difficulties plotting a line

Great! That was the idea.

mila_ayuhara
New Contributor III

Re: Difficulties plotting a line

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

Community Browser