topic Re: Logic Help1 in QlikView https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933154#M967783 <HTML><HEAD></HEAD><BODY><P>any suggestions</P></BODY></HTML> Fri, 25 Sep 2015 06:28:53 GMT abhaysingh 2015-09-25T06:28:53Z Logic Help1 https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933150#M967779 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hey Guys,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Need One Help</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I have one date field which containing the date with TimeStamp and its get Upated every seconds in Transaction Table.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I have a report in which Date field is there</P><P style="font-size: 13.3333px;">i.e Asset&nbsp; |&nbsp;&nbsp; Sensor&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; DateRecorded&nbsp;&nbsp;&nbsp;&nbsp; | Value</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 12:00:01 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12344</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 12:00:02 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12345</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 12:00:03 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12346</SPAN></P><P style="font-size: 13.3333px;">.</P><P style="font-size: 13.3333px;">..so on</P><P style="font-size: 13.3333px;">..</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 12:00:30 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12347</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015&nbsp; 01:00:01 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12348</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">and so on</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">updated in transaction Table<BR /></SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I want to Create a&nbsp; Interval like 10 min, 30 min, 1 hour, 2 hour etc</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Now i want when i select any Interval Suppose 10 Min, the Report Should Display like Below</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; Asset&nbsp; |&nbsp;&nbsp; Sensor&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; DateRecorded&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Value</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 12:00:01 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12344</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 12:00:11 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12345</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 12:00:21 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12346</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 12:00:31 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12347</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">and so on</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">and Same if i select 30 Min the report should update like below<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Asset&nbsp; |&nbsp;&nbsp; Sensor&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; DateRecorded&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Value</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 12:00:01 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12344</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 12:00:31 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12345</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 01:00:01 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12346</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 24-09-2015 01:00:31 AM |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12348</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">DateRecorded Field i am getting in Transaction Table</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">TxnTable:</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Load<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Field1,</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Field2,</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">DateRecorded</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">from Source;</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Please Suggest how i can achieve it..<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Thu, 24 Sep 2015 11:38:39 GMT https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933150#M967779 abhaysingh 2015-09-24T11:38:39Z Re: Logic Help1 https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933151#M967780 <HTML><HEAD></HEAD><BODY><P>See: <A href="https://community.qlik.com/thread/182212">Logic Help</A></P></BODY></HTML> Thu, 24 Sep 2015 12:34:34 GMT https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933151#M967780 marcus_sommer 2015-09-24T12:34:34Z Re: Logic Help1 https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933152#M967781 <HTML><HEAD></HEAD><BODY><P>Hey Marcus i have attached some sample data in Logic Help Post.. Could u please look into it..</P><P></P><P>Regards</P><P>Abhay</P></BODY></HTML> Fri, 25 Sep 2015 06:09:00 GMT https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933152#M967781 abhaysingh 2015-09-25T06:09:00Z Re: Logic Help1 https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933153#M967782 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/182212">Logic Help</A></P></BODY></HTML> Fri, 25 Sep 2015 06:09:49 GMT https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933153#M967782 abhaysingh 2015-09-25T06:09:49Z Re: Logic Help1 https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933154#M967783 <HTML><HEAD></HEAD><BODY><P>any suggestions</P></BODY></HTML> Fri, 25 Sep 2015 06:28:53 GMT https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933154#M967783 abhaysingh 2015-09-25T06:28:53Z Re: Logic Help1 https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933155#M967784 <HTML><HEAD></HEAD><BODY><P>Kindly revert.....</P></BODY></HTML> Fri, 25 Sep 2015 09:53:19 GMT https://community.qlik.com/t5/QlikView/Logic-Help1/m-p/933155#M967784 abhaysingh 2015-09-25T09:53:19Z