Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

Date Format

I have a Data set which has "Time" as "17-SEP-12 01.08.47.530179000 AM"

So i need to divide taht time to,

Year

Month

Day

Hours

minutes

Please help.

At least tell me how to devide it in to Year,Month,Day

Thanks

28 Replies
hic
Former Employee
Former Employee

A second small error in Jonathans answer: The Load should start with "Load *, Month(" instead of "Load Month("

HIC

anuradhaa
Partner - Creator II
Partner - Creator II
Author

Thanks All for your Help,

I have used Jonathan Dienst Code for load the time,

Then I have load my other data as a seperate table, then join those two tables.

It works

Thanks Everyone for your kind support

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

I have corrected for the otyher issue that Henric spotted. This means that you could load all the data in a single pass, rather than loading separatly and joining.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
omerfaruk
Creator
Creator

Hi,

I am trying to create a chart to display amount of cases occurring in each time of the day (such as 13.00 - 3 cases)

I have a calendar. I would like to add Hour as another field to my calendar. So just like I see the # of cases for lets say month period, I would like to see them in hour period. By this way I will have an idea about the hours in which cases are most and less..

I've tried to do this without changing the script using this calculated dimension  " Time([Case Open Time], 'hh') "  , but it displayed the hours for every date entry..(e.g. 12 12 12 13 13 14 14 14 14).

In either way how can I achieve implementing this ?

omerfaruk
Creator
Creator

Hi,

Hour function resolved this issue.

Thanks.

Anonymous
Not applicable

is your > (Date) < in your script a QV function or the designated field that needs to be inserted into that spot?

Thanks

hic
Former Employee
Former Employee

It is a field defined in the following Load statement:

LOAD *,

    Month(Date) As Month,

    Year(Date) As Year,

    Day(Date) as Day,

    Hour(Date) As Hour,

    Minute(Date) As Minute;

LOAD Date(Date#(TIME, 'DD-MMM-YY hh.mm.ss.fffffffff tt')) As Date,

    MACHINE_NAME, ...

See more on Preceding Load

HIC

RaimondsR
Contributor
Contributor

Hi!

Maybe someone could help me to solve one problem.

Time format, which comes from one report is dd.mm.yy hh:mm:ss (there is space before dd), what i should get is dd.mm.yyyy, maybe anyone could help with this?

At moment tried use those 2 formulas :

Date(Date#( Datums,'DD.MM.YYYY')) as add_date,

Date(Floor(TimeStamp#(Datums,'DD/MM/YY hh:mm:ss')),'DD/MM/YYYY') as add_date,

Bouth formulas returns "-".

Anil_Babu_Samineni

This is old post, Please start google before post an new thread? BTW, May be try

Date(Floor(TimeStamp#(Datums,'DD.MM.YY hh:mm:ss')),'DD/MM/YYYY') as add_date,

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)