Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
bhusjosh
Contributor III
Contributor III

Interval for 5 minutes

Dear all,

i need to create a interval of every 5 minutes for a data with DD/MM/YY DD:HH format time.

Need to check the missing and duplicate values for the same, following is the data pattern.

Time

29/09/17 06:05
29/09/17 06:00
29/09/17 05:55
29/09/17 05:50
29/09/17 05:45
29/09/17 05:45
29/09/17 05:35
29/09/17 05:30

i am trying to figure out it with peek function but no luck.

1 Reply
Anil_Babu_Samineni

May be look https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFun...

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful