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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

class range two hours

hi i need to class two hours !!

for example

range
operatorhour login
hour logout

09:00-10:00

alex08:3010:50
simon09:0009:30

usually i used clas with only one value !!!

how can i do ?

2 Replies
sunny_talwar

I don't really understand what you are trying to do here.

Not applicable
Author

thanks for reply, i try to explain better

my table have multiple timestamp login of operators

operatorloginlogout
alex09:3010:50
simon10:2013:10

I need to count the minutes to login for each operator divided by hour (variable, can be 60 minutes, 30 minutes, etc)


operatorrangeminutes logged
alex09:00 to 10:0030
10:00 to 11:0050
simon10:00 to 11:00

40

11:00 to 12:0060
12:00 to 13:0060
13:00 to 14:0010


usually for range a field i use "class", but my problem here i have two fields: login and logout..