topic Re: Re: Seperate timestamp use in pivot in QlikView

Seperate timestamp use in pivot

Wed, 16 Jul 2014 11:36:56 GMT

I have a table that is a timestamp.

Each day there are diferrent times.

Fe:

31/12/2013 4:30:45

31/12/2013 5:38:47

31/12/2013 5:30:00

01/01/2014 4:25:15

01/01/2014 4:12:23

I want to show in a pivot table all the different dates an when you click further al the times for that day.

Something like this:

31/12/2013 4:30:45

5:38:47

5:30:00

01/01/2014 4:25:15

4:12:23

I added a qvw with sample data.

Re: Seperate timestamp use in pivot

ashfaq_haseeb — Wed, 16 Jul 2014 11:50:20 GMT

Have a look at the attached document

Regards

ASHFAQ

Re: Seperate timestamp use in pivot

Wed, 16 Jul 2014 12:17:06 GMT

That worked, I forgot to fill in an expression.

Thanks!

Re: Seperate timestamp use in pivot

ashfaq_haseeb — Wed, 16 Jul 2014 12:19:17 GMT

Glad That it worked.

Regards

ASHFAQ

Re: Seperate timestamp use in pivot

Wed, 16 Jul 2014 12:41:35 GMT

Do you happen to know how to calculate the timedifference between each time?

Re: Seperate timestamp use in pivot

ashfaq_haseeb — Wed, 16 Jul 2014 12:52:09 GMT

use above function

RegardsASHFAQ

Re: Seperate timestamp use in pivot

Wed, 16 Jul 2014 13:26:41 GMT

this calculates the interval that I need:

=below(emptyings_time,1)-(emptyings_time)

How do I get this in a time format?

Because I want to display this in a chart.

Re: Seperate timestamp use in pivot

ashfaq_haseeb — Wed, 16 Jul 2014 13:32:57 GMT

May be like this

Interval(MakeTime(Floor(below(emptyings_time,1)-(emptyings_time)), Round(Frac(below(emptyings_time,1)-(emptyings_time))*60)))

Regards

ASHFAQ

Re: Seperate timestamp use in pivot

Wed, 16 Jul 2014 13:42:57 GMT

Doesn't work unfortunatly.

Re: Re: Seperate timestamp use in pivot

ashfaq_haseeb — Wed, 16 Jul 2014 13:56:39 GMT

Hi,

Have a look at the attached document.

You can hide column(1)

Regards

ASHFAQ