Modal time interval

[qw_jakub]

Hello,

Suppose I have a simple table: ID , timestamp of entry, and timestamp of exit. Entry and exit always happen in the same day.

I'm looking for an expression which would return the beginning of the time interval where there are most IDs inside.

I have made a master Clock table with all possible daytimes and an interval match on entry and exit times but am not sure where to go next.

Thanks for any tips

Jakub

[IAMDV]

Hi Jakub,

I kind of understood your question but not very clear. So it would be great if you can post the sample app with whatever you have done so far. Also, I'd recommend pre-calculating this in the script and just aggregating in UI based on user selection. Have you considered using the Group By clause in the load script to cluster the counts for each interval?

I hope this helps! Good luck.

Cheers,

DV

www.QlikShare.com

[er_mohit]

see the attached file for using date in interval match

[qw_jakub]

Thank you both for your answers, I will study the attached file.

To make clearer what I'm after, I have attached a sample file.

The "Statistics" table gives me the information I need but not in a good presentation.

I use the master clock time as a dimension and count(Id) an expression. When I sort the table by the count, the "Daytime" value in the top row Is the value I am after.

This way of doing this has several disadvantages: I see all possible times even though I am interested only for the top one; I have to use set analysis to have the males and females count in separate columns and I have to resort the table when I want to see the top time for each dimension element or the total.

I would like to be able to use the gender as a dimension and an expression which would return the time with the highest ID count.

This means for this sample file:

Total - 10:35

Male - 10:35

Female - 14:45

Thanks for any hints on how I could achieve this.

J.