topic Re: Need duration to be displayed in timeline chart in App Development

Need duration to be displayed in timeline chart

Sat, 13 Feb 2016 01:36:46 GMT

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

Re: Need duration to be displayed in timeline chart

Gysbert_Wassenaar — Sat, 13 Feb 2016 06:38:53 GMT

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.

Re: Need duration to be displayed in timeline chart

Mon, 15 Feb 2016 12:50:40 GMT

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?

Re: Need duration to be displayed in timeline chart

Gysbert_Wassenaar — Mon, 15 Feb 2016 17:31:23 GMT

Please post a small qlikview document that demonstrates the problem.

Re: Need duration to be displayed in timeline chart

Tue, 16 Feb 2016 14:08:02 GMT

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

Re: Need duration to be displayed in timeline chart

Gysbert_Wassenaar — Wed, 17 Feb 2016 16:43:33 GMT

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