Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I format a date in a pivot table ?

Hi All,

I have a sheet object (a pivot table) which displays a date as YYYYMMDD. How can I format it to display as DD/MM/YYYY ?

Thanks

MV

9 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Split (with string functions MID) into DD MM YYYY thes use Makedate function

Not applicable
Author

Can you give me an example please ? I'm assuming this is in the LOAD statement ?

marcus_sommer

I suggest to do this (maybe as an additionally field) within the script maybe in a master-calendar instead in (many?) gui-objects, see also: How to use - Master-Calendar and Date-Values.

- Marcus

alexandros17
Partner - Champion III
Partner - Champion III

MakeDate(Mid(myDate,1,4), Mid(myDate,5,2), Mid(myDate,7,2))

let me know

Anonymous
Not applicable
Author

Two ways:

1) In the script at main tab:

Set DateFormat='DD/MMM/YYYY';

2) Right Click on Pivot table and go to number tab, select the field from left list and override the date format.

Not applicable
Author

The date field doesn't appear in the list in the left as it's a dimension, not an expression.

Anonymous
Not applicable
Author

oky, In your dimension tab, say Date is your field:

try this:

date(YourDate,'DD/MMM/YYYY')

Colin-Albert

Has the data been loaded as a date field?

Have a look at this post which shows how to load dates correctly.     Get the Dates Right

sasiparupudi1
Master III
Master III

try

date(date#(Yourdate,'YYYYMMDD'),'DD/MM/YYYY')

hth

Sasi