Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dynamic_girl
Creator
Creator

conversion of decimal values to date format

how to convert conversion of decimal values to date format

1 Solution

Accepted Solutions
Colin-Albert

I would check the date format settings in your load script. They may be different in the two applications.

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

View solution in original post

6 Replies
prieper
Master II
Master II

TIMESTAMP(MyField) should do

Colin-Albert

date(floor(YourFieldName))  will convert the decimal timestamp value to a date and removes the time component

time(frac(YourFieldName)) will convert the decimal timestamp value to a time removing the date component


timestamp(YourFieldName) will convert the decimal value to a timestamp


It is better to split timestamp data into separate date & time fields in Qlik as this will reduce the number of unique data values, and so reduce the footprint of your application.

If you only need the date then just create a date field  - 1 value per day rather than storing potentially thousands of values to the millisecond!

dynamic_girl
Creator
Creator
Author

thankyou,

am experiencing something very weird,

there is one qvd when am loading it as it is its showing me date in correct format ,

when am loading it in another qvw application,its showing incorrect format,

is there any settings in qlikview in this case

as both are the same files ,

hariprasathr_cg
Contributor III
Contributor III

Post the sample data. we would be able to fix this

psilva001
Creator
Creator

DATE(DATE#(Timestamp([YourField]), 'QVDDateFormat'), 'Current Format')


doesn't matter if 'QVDDateFormat' and 'Current Format' are equals

Colin-Albert

I would check the date format settings in your load script. They may be different in the two applications.

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';