Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner
Partner

hi 

attach is an example of what you asked 

it's using intervalmatch function 

View solution in original post

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

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)

Partner
Partner

hi 

attach is an example of what you asked 

it's using intervalmatch function 

View solution in original post

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

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

Contributor
Contributor

thank you lironbaram 😉