Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Re: Need duration to be displayed in timeline chart

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

Re: Need duration to be displayed in timeline chart

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?

Highlighted

Re: Need duration to be displayed in timeline chart

Please post a small qlikview document that demonstrates the problem.


talk is cheap, supply exceeds demand
Not applicable

Re: Need duration to be displayed in timeline chart

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

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


talk is cheap, supply exceeds demand
Community Browser