topic Re: Show Start Time and End Time in QlikView

Show Start Time and End Time

rustyfishbones — Fri, 07 Jul 2017 14:10:12 GMT

Hi,

I am creating a straight table with transactions for today.

I want to add a Dimension for each user showing the first transaction time and the last transaction time

User Qty Start Time End Time

Alan 1000 08:15 14:59

each transaction has a start time and an end time, so I could have hundred of them for each user.

I only want to display the very first StartTime for the selected Day and the very last EndTime for the selected day

What's the best approach.

Anil_Babu_Samineni — Fri, 07 Jul 2017 14:11:33 GMT

That is possible, Will you able to provide sample data set with Days combination ?

rustyfishbones — Fri, 07 Jul 2017 14:16:05 GMT

Hi Please see the attached sample data file

rustyfishbones — Fri, 07 Jul 2017 14:16:55 GMT

I am not looking to create this in the script, just within the chart Dimension

sunny_talwar — Fri, 07 Jul 2017 14:25:41 GMT

Like this

rustyfishbones — Fri, 07 Jul 2017 14:32:34 GMT

Yes, that's it, I did try that as a calculated Dimension but it returned an error.

This is what actually worked for me.

TIME(MIN(StartTime),'hh:mm')

TIME(MAXEndTime),'hh:mm')

and as an Expression not a Dimension

sunny_talwar — Fri, 07 Jul 2017 14:35:55 GMT

As a dimension, you would need Aggr()...

=Aggr(Time(Min(StartTime), 'hh:mm'), Picker)

=Aggr(Time(Max(EndTime), 'hh:mm'), Picker)

rustyfishbones — Fri, 07 Jul 2017 14:41:24 GMT

Thanks Again