Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Date Formatting

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

6 Replies

Re: Date Formatting

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

Re: Date Formatting

If you want the date only then use

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

Re: Date Formatting

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

MVP
MVP

Re: Date Formatting

Hi

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

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

Re: Date Formatting

try

date(floor(field))

vardhancse
Valued Contributor III

Re: Date Formatting

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,