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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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..