Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Showing Status Changes on a timeline

Hello

i have a log db with information on status.

I want to present this information on a timeline in a chart.

Unfortunately the chart shows only the status info in groups. Which dimention or sorting is missing so it shows is correctly?

Thx in advance

Status.jpg

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

So i figured it out:

the dimention should be as proposed by swuehl <timestamp>

the formula itself is sum(duration). In the example by swuehl 1 is used as formula - a suppose this can be done when your dimention and the granulatity of the data is the same.

in my case (dynamic length of a status) it was not possible to achieve like this as i would have needed the data on the granularity of 1 minute..

I hope it helps somebody for the furure:

Status2.jpg

p.s: dont forget to sort the timestamp.

cheers //chesterluck

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Unable to understand your requirement, kindly explain with detail and if possible share sample data.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
MVP
MVP

Your dimension should be a date or timestamp related to your status, maybe the Start field?

And have a look maybe in something like

Re: Complex timeline.

Highlighted
Creator II
Creator II

So i figured it out:

the dimention should be as proposed by swuehl <timestamp>

the formula itself is sum(duration). In the example by swuehl 1 is used as formula - a suppose this can be done when your dimention and the granulatity of the data is the same.

in my case (dynamic length of a status) it was not possible to achieve like this as i would have needed the data on the granularity of 1 minute..

I hope it helps somebody for the furure:

Status2.jpg

p.s: dont forget to sort the timestamp.

cheers //chesterluck

View solution in original post