Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need duration to be displayed in timeline chart

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))

)

Post.png

Any advice would be appreciated?


Regards,

Radhakrishnan

5 Replies
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.


talk is cheap, supply exceeds demand
Not applicable
Author

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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.


talk is cheap, supply exceeds demand