Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
chesterluck
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
chesterluck
Creator II
Creator II
Author

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
kaushiknsolanki

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".
swuehl
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.

chesterluck
Creator II
Creator II
Author

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