topic Interval for 5 minutes in QlikView https://community.qlik.com/t5/QlikView/Interval-for-5-minutes/m-p/1443995#M609736 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>i need to create a interval of every 5 minutes for a data with DD/MM/YY DD:HH format time.</P><P>Need to check the missing and duplicate values for the same, following is the data pattern.</P><P></P><P>Time<SPAN style="font-size: 10pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 118px;"><TBODY><TR><TD height="20" width="118">29/09/17 06:05</TD></TR><TR><TD height="20">29/09/17 06:00</TD></TR><TR><TD height="20">29/09/17 05:55</TD></TR><TR><TD height="20">29/09/17 05:50</TD></TR><TR><TD height="20">29/09/17 05:45</TD></TR><TR><TD height="20">29/09/17 05:45</TD></TR><TR><TD height="20">29/09/17 05:35</TD></TR><TR><TD height="20">29/09/17 05:30</TD></TR></TBODY></TABLE><P></P><P>i am trying to figure out it with peek function but no luck.</P></BODY></HTML> Thu, 21 Dec 2017 13:01:59 GMT bhusjosh 2017-12-21T13:01:59Z Interval for 5 minutes https://community.qlik.com/t5/QlikView/Interval-for-5-minutes/m-p/1443995#M609736 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>i need to create a interval of every 5 minutes for a data with DD/MM/YY DD:HH format time.</P><P>Need to check the missing and duplicate values for the same, following is the data pattern.</P><P></P><P>Time<SPAN style="font-size: 10pt;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 118px;"><TBODY><TR><TD height="20" width="118">29/09/17 06:05</TD></TR><TR><TD height="20">29/09/17 06:00</TD></TR><TR><TD height="20">29/09/17 05:55</TD></TR><TR><TD height="20">29/09/17 05:50</TD></TR><TR><TD height="20">29/09/17 05:45</TD></TR><TR><TD height="20">29/09/17 05:45</TD></TR><TR><TD height="20">29/09/17 05:35</TD></TR><TR><TD height="20">29/09/17 05:30</TD></TR></TBODY></TABLE><P></P><P>i am trying to figure out it with peek function but no luck.</P></BODY></HTML> Thu, 21 Dec 2017 13:01:59 GMT https://community.qlik.com/t5/QlikView/Interval-for-5-minutes/m-p/1443995#M609736 bhusjosh 2017-12-21T13:01:59Z Re: Interval for 5 minutes https://community.qlik.com/t5/QlikView/Interval-for-5-minutes/m-p/1443996#M609737 <HTML><HEAD></HEAD><BODY><P>May be look <A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/class.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/class.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/class.htm</A></P></BODY></HTML> Thu, 21 Dec 2017 16:49:48 GMT https://community.qlik.com/t5/QlikView/Interval-for-5-minutes/m-p/1443996#M609737 Anil_Babu_Samineni 2017-12-21T16:49:48Z