topic Re: Showing Status Changes on a timeline in QlikView

Showing Status Changes on a timeline

Anonymous — Mon, 04 Apr 2016 09:55:46 GMT

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

Re: Showing Status Changes on a timeline

kaushiknsolanki — Mon, 04 Apr 2016 10:00:53 GMT

Hi,

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

Regards,

Kaushik Solanki

Re: Showing Status Changes on a timeline

swuehl — Mon, 04 Apr 2016 10:05:57 GMT

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.

Re: Showing Status Changes on a timeline

Anonymous — Mon, 04 Apr 2016 12:10:23 GMT

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:

p.s: dont forget to sort the timestamp.

cheers //chesterluck