tag:blogger.com,1999:blog-3174073825360154810.post3881795617084582138..comments2022-12-06T05:49:47.306-05:00Comments on QlikView Maven: Time interval between two timestamps-TBhttp://www.blogger.com/profile/08386812862574514289noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-3174073825360154810.post-48358631449039661672014-06-17T11:48:00.898-04:002014-06-17T11:48:00.898-04:00You would want to try several alternatives but I t...You would want to try several alternatives but I think you would need to concatenate several text functions together. For example, if your time expression is XXX then something like this could work:<br /><br />=floor(upper(time(XXX,'hh'))/24)&' days '&mod(upper(time(XXX,'hh')),24)&' hrs '&time(XXX,'mm')&' mins '&time(XXX,'ss')&' seconds'<br /><br />I think I would put that into a variable defined to accept a parameter or argument. Then put the time expression into the argument. I have a blog posting about that-- search on "qlikview maven Variable That Acts Like a User-Defined Function".-TBhttps://www.blogger.com/profile/08386812862574514289noreply@blogger.comtag:blogger.com,1999:blog-3174073825360154810.post-77629824803300870632014-06-17T05:48:22.929-04:002014-06-17T05:48:22.929-04:00Hi,
What if we want to display this time in the ...Hi,<br /><br />What if we want to display this time in the following format:<br /><br />(2 days 20 hrs 22 mins 32 seconds)<br /><br />instead of <br /><br />(02 20:22:32)<br /><br />Do you have any suggestion?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3174073825360154810.post-13385996123556507802012-12-27T10:48:38.567-05:002012-12-27T10:48:38.567-05:00Most of my blog postings are things you cannot fin...Most of my blog postings are things you cannot find in the manual or unusual solutions that I've never seen anyone else use.<br />But, for timestamps and time arithmetic, you can find many postings and ideas on QlikCommunity.<br /> -TBhttps://www.blogger.com/profile/08386812862574514289noreply@blogger.comtag:blogger.com,1999:blog-3174073825360154810.post-75430018714214116002012-12-21T17:12:45.702-05:002012-12-21T17:12:45.702-05:00Tim,
Do you recall the original approach you took...Tim,<br /><br />Do you recall the original approach you took for this posting? <br /><br />Having the two approaches in contrast might help some folks find the better approach when they search for examples doing the original.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3174073825360154810.post-57584489646268984232010-11-12T17:37:28.874-05:002010-11-12T17:37:28.874-05:00That's a great suggestion. I'm going to ch...That's a great suggestion. I'm going to change the posting to use that idea. Thanks!-TBhttps://www.blogger.com/profile/08386812862574514289noreply@blogger.comtag:blogger.com,1999:blog-3174073825360154810.post-68219149425084225022010-11-12T04:23:21.430-05:002010-11-12T04:23:21.430-05:00Hello, Tim.
I think it would be more easier :) Yo...Hello, Tim.<br /><br />I think it would be more easier :) You can use an interval() function with above/below chart functions. For example,<br />interval([XDT] - below([XDT]))<br /><br />best regards, <br />Anatoly Pyatygo<br />qvrus.blogspot.comsparurhttps://www.blogger.com/profile/13955999751662131069noreply@blogger.com