Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Seperate timestamp use in pivot

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.

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Have a look at the attached document

Regards

ASHFAQ

View solution in original post

9 Replies
ashfaq_haseeb
Champion III
Champion III

Have a look at the attached document

Regards

ASHFAQ

Not applicable
Author

That worked, I forgot to fill in an expression.

Thanks!

ashfaq_haseeb
Champion III
Champion III

Glad That it worked.

Regards

ASHFAQ

Not applicable
Author

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

ashfaq_haseeb
Champion III
Champion III

use above function

RegardsASHFAQ

Not applicable
Author

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.

ashfaq_haseeb
Champion III
Champion III

May be like this

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

Regards

ASHFAQ

Not applicable
Author

Doesn't work unfortunatly.

ashfaq_haseeb
Champion III
Champion III

Hi,

Have a look at the attached document.

You can hide column(1)

Regards

ASHFAQ