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: 
xtrimf
Creator
Creator

Dynamic interval

Hello,

I have the following table:

                                                                                                                                         

Phone1Phone2Call directiondatetime
123789OUT01/01/201210:00
123456OUT01/01/201210:05
123456OUT01/01/201210:45
123456IN01/01/201210:30
123456IN01/01/201210:50
123789IN01/01/201210:22
123789IN01/01/201210:55
123456OUT01/01/201211:30
123789OUT01/01/201211:00

                                                                                                                                                    

and I have also a dynamic variable:

interval.jpg

I need to create a report that shows all the call that took place within 20 minutes (or any other value from the slyder) between any couple Phone1-Phone2.

For example in this case and a 20 minute interval it will show:

Phone1Phone2Call directiondatetime
123456IN01/01/201210:30
123456OUT01/01/201210:45
123456IN01/01/201210:50

is it possible?

tnx

1 Reply
xtrimf
Creator
Creator
Author

anyone??