Need duration to be displayed in timeline chart

[#1]

Hi,

In a bar chart used one regular dimension and a value list ( (i.e) - ValueList('StartDate','FinishDate ) under dimensions and in measures used below expression

It displays a date value way far behind as in screen below, but Need to display duration of days on Mouse over in bar chart for timeline.

if(ValueList('StartDate','FinishDate')='FinishDate',

max(DayEnd(FinishDate))-Min(DayStart(StartDate))

,Min(daystart(StartDate))

)

Any advice would be appreciated?

Regards,

Radhakrishnan

[Gysbert_Wassenaar]

Try adding some formating:

if(ValueList('StartDate','FinishDate')='FinishDate',

Interval(max(DayEnd(FinishDate))-Min(DayStart(StartDate)),'d')

,Date(Min(daystart(StartDate)),'YYYY-MM-DD')

)

And set the Number formatting option of the measure to Auto.

[#3]

thanks Gysbert, it works well in Timeline chart extension.

i'm creating Timeline in bar chart, since the dimension used is a drill down object. Then this expression does not work. Any suggestion?

[Gysbert_Wassenaar]

Please post a small qlikview document that demonstrates the problem.

[#5]

attached qvf and sample data to the application. Need below chart in sheet to display the duration of days on each bar

[Gysbert_Wassenaar]

Ok, I understand what you want. Afaik this is not possible with the bar chart.