Solved: Time format - Qlik Community

Report Inappropriate Content · ‎2015-03-24

Hi QV team,

This is actual script.

Timeformat:

LOAD * INLINE [

time_minuts

0600

0610

0630

0640

0645

0650

0655

];

I require above time format like this

06:00

06:10

06:30

06:40

06:45

06:50

06:55

PrashantSangle · ‎2015-03-24

Hi,

use

time(time#(time_minuts,'hhmm'),'hh:mm')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2015-03-24

Hi,

use

time(time#(time_minuts,'hhmm'),'hh:mm')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

amit_saini · ‎2015-03-24

Hi,

Like this???

Thanks,

AS

sagarkharpude · ‎2015-03-24

try this

Timeformat:

LOAD * INLINE [

time_minuts

0600

0610

0630

0640

0645

0650

0655

];

LOAD *,

Left(time_minuts,2)&':'&right(time_minuts,2) as times

Resident Timeformat;

DROP Table Timeformat;

Report Inappropriate Content · ‎2015-03-24

Hi Max,

Thank you for gave correct answer.

Time format

Related Topics