Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qw_jakub
Partner - Contributor III
Partner - Contributor III

Modal time interval

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

3 Replies
IAMDV
Master II
Master II

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
Master II
Master II

see the attached file for using date in interval match

qw_jakub
Partner - Contributor III
Partner - Contributor III
Author

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.