topic Re: convert epoch time to EST with consideration of DST in QlikView

convert epoch time to EST with consideration of DST

Thu, 16 Jul 2015 10:42:58 GMT

convert epoch time to EST with consideration of DST

start_time as 1426807749

Timestamp(25569 + start_time / 86400) as starttimeGMT . This gives data in GMT how can i get the corresponding data in EST,

Re: convert epoch time to EST with consideration of DST

MarcoWedel — Thu, 16 Jul 2015 10:56:48 GMT

=ConvertToLocalTime(Timestamp(25569 + 1426807749 / 86400),'GMT-05:00')

Re: convert epoch time to EST with consideration of DST

sunny_talwar — Thu, 16 Jul 2015 11:08:39 GMT

Hey MarcoWedel‌

Just think out loud, since QlikView has a function to convert time, do they have inbuilt function to convert Kgs to Lbs (and vice versa) or other metric to imperial (and vice versa) conversion functions????

Best,

Sunny

Re: convert epoch time to EST with consideration of DST

MarcoWedel — Thu, 16 Jul 2015 20:55:23 GMT

Hi,

none that I know of.

But it should be possible to implement some parameterized variables for this purpose, like:

SET ConvertKgsToLbs = ($1/0.45359237);

table1:
LOAD *,
    $(ConvertKgsToLbs(kg)) as lb;
LOAD IterNo()/10 as kg
AutoGenerate 1
While IterNo()/10<=10;

hope this helps

regards

Marco

Re: convert epoch time to EST with consideration of DST

sunny_talwar — Mon, 20 Jul 2015 10:57:18 GMT

MarcoWedel‌ this is amazing. Thanks for putting this together. I love how you make everything so simple.

Re: convert epoch time to EST with consideration of DST

sunny_talwar — Mon, 20 Jul 2015 16:52:17 GMT

Marco, I hope you don't think that my comment above was sarcastic. I was just trying to learn something new from you. Our friend Binod thought that I should have not done it. I respect his comments and would like to apologize if you thought my comment above was in-appropriate.

Best,

Sunny

P.S. wanted to send you a private message, but since you are not following me, I cannot message you

Re: convert epoch time to EST with consideration of DST

MarcoWedel — Mon, 20 Jul 2015 19:25:26 GMT

Hi Sunny,

although not formally following you (i.e. until 5 minutes ago ) I did follow your recent activities and therefore would never have considered your question anything else than genuine interest in QlikView.

Qlik on

regards

Marco

Re: convert epoch time to EST with consideration of DST

sunny_talwar — Mon, 20 Jul 2015 19:47:47 GMT

Awesome Thank you Marco!

Re: convert epoch time to EST with consideration of DST

Tue, 21 Jul 2015 06:54:13 GMT

hey sunny sorry if my comment hurt you .. i thought i had asked a very stupid question in this thread so thought your comments otherwise .. i later realized i misunderstood your comment.. hence deleted my comment .. hope you understand ..

thanks for understanding

Re: convert epoch time to EST with consideration of DST

sunny_talwar — Tue, 21 Jul 2015 10:10:30 GMT

Binod, I am not hurt .

Also I think you accidentally marked the incorrect response as correct answer. Please reward Marco's response as the correct answer.

Best,

Sunny