Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

count connexion with startdate and endate

HELLO please if you can help me 

i have user with session start and end 

user StartDate EndDate
1 2020-03-03 06:12 :27 2020-03-03 14:46 :04
2 2020-03-03 07:05 :34 2020-03-03 07:55 :19
3 2020-03-03 07:19 :06 2020-03-03 14:48 :13
4 2020-03-03 09:37 :36 2020-03-03 10:38 :28
5 2020-03-03 12:10 :15 2020-03-03 12:22 :34
6 2020-03-03 14:35 :28 2020-03-03 16:31 :02
7 2020-03-03 14:46 :05 2020-03-03 14:56 :52
8 2020-03-03 14:51 :37 2020-03-03 15:30 :00
9 2020-03-03 14:51 :41 2020-03-03 21:39 :45
10 2020-03-03 14:52 :42 2020-03-03 16:14 :15
11 2020-03-03 15:13 :49 2020-03-03 20:28 :02
12 2020-03-03 15:33 :28 2020-03-03 15:38 :37
13 2020-03-03 18:04 :40 2020-03-03 18:07 :11
14 2020-03-04 12:32 :26 2020-03-04 21:35 :01
15 2020-03-05 06:43 :25 2020-03-05 06:59 :20
16 2020-03-05 07:09 :59 2020-03-05 21:34 :51
17 2020-03-05 20:23 :50 2020-03-05 20:24 :45
18 2020-03-05 20:25 :09 2020-03-05 20:26 :52
19 2020-03-05 20:27 :20 2020-03-05 20:28 :27
20 2020-03-05 20:31 :36 2020-03-05 20:32 :36
21 2020-03-05 20:52 :33 2020-03-05 20:53 :25
22 2020-03-06 06:49 :33 2020-03-06 15:55 :28
23 2020-03-06 07:57 :41 2020-03-07 00:18 :03
24 2020-03-06 10:07 :57 2020-03-06 16:10 :51
25 2020-03-07 07:46 :42 2020-03-07 08:02 :35
26 2020-03-08 10:23 :29 2020-03-08 10:25 :12
27 2020-03-08 10:25 :13 2020-03-08 10:30 :54
28 2020-03-08 10:27 :59 2020-03-08 10:32 :08
29 2020-03-08 16:24 :56 2020-03-08 16:26 :42
30 2020-03-08 16:26 :43 2020-03-08 16:28 :26
31 2020-03-08 16:32 :22 2020-03-08 16:33 :18
32 2020-03-08 16:33 :23 2020-03-08 16:35 :14
33 2020-03-09 07:31 :48 2020-03-09 19:53 :48
34 2020-03-09 08:10 :48 2020-03-09 18:48 :01
35 2020-03-09 19:09 :08 2020-03-10 03:23 :44

 

I will try to find out how many users I have actif in at a specific time on a graph(at 8H00. 9H00 ......20H00)

like here 

1 2020-03-03 06:12 :27 2020-03-03 14:46 :04
2 2020-03-03 07:05 :34 2020-03-03 07:55 :19
3 2020-03-03 07:19 :06 2020-03-03 14:48 :13
4 2020-03-03 09:37 :36 2020-03-03 10:38 :28

at 9H i have 3 user connected 

I tried to create a table which calculates the number of user connected in different hours but I did not succeed

can you help me please please 

Labels (1)
2 Solutions

Accepted Solutions
Highlighted
Partner
Partner

hi 

attach is an example of what you asked 

it's using intervalmatch function 

View solution in original post

Highlighted
Partner
Partner

hi

i didn't understood your question , 

for each date , you want to display only maximum of concurrent users ? 

if so you can do it like this 

max(aggr(Count(user),TimeStamp,[TimeStamp.autoCalendar.Date]))

if a reply is correct please mark it as answered, so other users can benefit from the solution 

thanks 

View solution in original post

6 Replies
Highlighted
Specialist II
Specialist II

See example attached based on your data; have a look at the formulas in the table to see how it is implemented

Highlighted
Contributor
Contributor

the example is just a sample I have 30000 LINE of a citrix database
I want to calculate the number of active session based on startdate and anddate

 

i wan like axes X :  hour and date

axe Y : count nombre of user actif ( where hour and date is between startdate and endate)

Highlighted
Partner
Partner

hi 

attach is an example of what you asked 

it's using intervalmatch function 

View solution in original post

Highlighted
Contributor
Contributor

hello lironbaram it's work  THANNNNK YOU VERY VERY MUCH

I have another question sltp I would like to take the maximum hour connection and display it on the date example:

day 03/03/2020  i have 13 USERS BUT 

03/03/2020  the max of user connecte in same time it's 4 at 12H

04/03/2020 the max its at 12H  it's 1

I WAN in 

axe X : timestamp.autocanlender.date

in Y : Max of connexion (user connected the same time ) like for 03/03/2020  i have 13 USERS BUT wan affiche 4 NOT 13 

?

THANK YOU V

Highlighted
Partner
Partner

hi

i didn't understood your question , 

for each date , you want to display only maximum of concurrent users ? 

if so you can do it like this 

max(aggr(Count(user),TimeStamp,[TimeStamp.autoCalendar.Date]))

if a reply is correct please mark it as answered, so other users can benefit from the solution 

thanks 

View solution in original post

Highlighted
Contributor
Contributor

thank you lironbaram 😉