topic Re: Date Formatting in QlikView

Date Formatting

Tue, 22 Apr 2014 12:52:53 GMT

How do I format a date field in a pivot table with making it an expression.

I have date as a dimension and it shows the time, I want the date only, I do not want the date as an expression b\c then it shows in the total section, which is not necessary

Re: Date Formatting

its_anandrjs — Tue, 22 Apr 2014 12:57:35 GMT

Do you have sample app for this or any sample data.

Re: Date Formatting

its_anandrjs — Tue, 22 Apr 2014 13:00:23 GMT

If you want the date only then use

Date(Date#(YourDateField,'DD/MM/YYYY'),'DD/MM/YYYY')

Re: Date Formatting

ashfaq_haseeb — Tue, 22 Apr 2014 13:01:42 GMT

Hi,

I suggest you to create two fields in you blackens one default date another with Date part only.

In your fronted use the date without time stamp.

you can remove time part as shown below.

Load *,

Date(floor(DATE_Field),'YYYY/MM/DD') as DatePart

from xyz;

Replace 'YYYY/MM/DD' with your date format.

Hope it helps

Regards

ASHFAQ

Re: Date Formatting

jonathandienst — Tue, 22 Apr 2014 13:05:14 GMT

It is usually better to do this in the load script. If you want date as a dimension, use the following calculated dimension (assumed date is the field name):

Date(Floor(date))

HTH

Jonathan

Re: Date Formatting

maxgro — Tue, 22 Apr 2014 13:05:46 GMT

try

date(floor(field))

Re: Date Formatting

vardhancse — Tue, 22 Apr 2014 13:06:35 GMT

Hi,

In script level while loading the fields create one additional field only with date, and rename as required.

Date(Floor(Field)) as xyz_date,