Discussion Board for collaboration related to QlikView App Development.
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
Do you have sample app for this or any sample data.
If you want the date only then use
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.
Date(floor(DATE_Field),'YYYY/MM/DD') as DatePart
Replace 'YYYY/MM/DD' with your date format.
Hope it helps
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):
In script level while loading the fields create one additional field only with date, and rename as required.
Date(Floor(Field)) as xyz_date,