topic Re: Hello Qlik Members in QlikView

Hello Qlik Members

vamseekrishna — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I am getting some problem to convert time format. I have time format it's in UTC mode, But i need to change into AEST(Australian Eastern Standard Time )..

Can please help how to convert UTC TO AEST(Australian Eastern Standard Time ) format..

Regards,

Vamsee

Re: Hello Qlik Members

neelamsaroha157 — Tue, 03 Jul 2018 15:53:27 GMT

May be this can solve your issue -

show data in correct time zone, can I do UTC+10 ?

Re: Hello Qlik Members

vamseekrishna — Thu, 05 Jul 2018 04:24:47 GMT

Hi Neelam,

Thank you for your response......

I am tried as same functions but it's not working.. right now I am easy to convert present local time to AEST....

In my data I have large of data like 2017,2016... I am not able to change that format...

Regards,

Vamsee Krishna

Re: Hello Qlik Members

neelamsaroha157 — Thu, 05 Jul 2018 12:50:44 GMT

Would you mind sharing some sample data?

Re: Hello Qlik Members

vamseekrishna — Fri, 06 Jul 2018 06:25:05 GMT

Hi neelam,

I have to 2 date format like

03/05/2018

4/05/2018

09/06/2018

this is one format

another one

like this

01/05/2018 4:51:07am

01/05/2018 4:51:13am

02/05/2018 8:02:57am

This is my date format in DB

Regards,

Vamsee

Re: Hello Qlik Members

jyothish8807 — Fri, 06 Jul 2018 06:55:05 GMT

Hi Namsee,

Try like this:

Load

Date,

ConvertToLocalTime( Alt(date#(Date,'DD/MM/YYYY'),timestamp(timestamp#(Date,'DD/MM/YYYY hh:mm:sstt'))),'Sydney') as New_Date;

LOAD * INLINE [

Date

3/5/2018

4/5/2018

9/6/2018

01/05/2018 4:51:07am

01/05/2018 4:51:13am

02/05/2018 8:02:57am

];

Br,

Re: Hello Qlik Members

vamseekrishna — Fri, 06 Jul 2018 06:58:04 GMT

Thank you I will try on this

Regards,

Vamsee