topic Re: In App, Datetime Fields are getting displayed in Number format? What would be fix? in QlikView

In App, Datetime Fields are getting displayed in Number format? What would be fix?

Tue, 02 Jun 2015 05:56:14 GMT

Hi Guys,

In my applications, I can see when I select a date or Datetime field It is displaying as number but my expectation is It should be in format YYYY-MM-DD hh:mm:ss[.fff] TT as in my Script I have used this format.

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='hh:mm:ss TT';

SET DateFormat='YYYY-MM-DD';

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

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET HidePrefix='%';

There is any simple fix for this?

I know end user is having option to change the format by following these steps:

List Box or Object Properties-->More-->Number-->Override Default Settings-->select you format

Is there any other method so that we can define this at application level during design so that each user should not go and change the format?

Re: In App, Datetime Fields are getting displayed in Number format? What would be fix?

vardhancse — Tue, 02 Jun 2015 05:59:10 GMT

Hi,

For the fields while loading we can add the functions like:

Date(Floor(Field)) as Date,

Time(Field) as time,

so that as per the given format the data and time will be displayed and not required to format individual objects wise.

Re: In App, Datetime Fields are getting displayed in Number format? What would be fix?

jonathandienst — Tue, 02 Jun 2015 06:03:35 GMT

Either format the value on load:

LOAD ....

Date(DateField) As Date,

....

or format using the Document Properties | Number tab.

If your value is a timestamp, you should split it into date and time fields (if the time is necessary) as suggested above.

But use this expression for time: Time(Frac(Field)) as Time;

Re: In App, Datetime Fields are getting displayed in Number format? What would be fix?

Tue, 02 Jun 2015 06:05:38 GMT

Hi Sasi,

Thanks for your quick response.

I am afraid to add any convert function in my Script as it is tedious task and may impact performance.

I discover easy way to do this:

Open the App in Desktop -->Go to Settings--> Document Properties-->Number-->Select the field which you want to Format-->Click on Number Format Settings Options like Date or Time Or TimeStamp-->Define your Format (In My case default is coming as YYYY-MM-DD hh:mm:ss[.fff] TT' )-->Click on Apply.

Reload and Publish

Re: In App, Datetime Fields are getting displayed in Number format? What would be fix?

vardhancse — Tue, 02 Jun 2015 06:08:14 GMT

Correct what we are doing in front end is same as conversion in back end while loading itself, in so many cases we will have the date field is a combination of date, time and so we can split the date & time separately.