Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can i change the date format in the pivot table?
Now it shows dd,mm.yyyy.
How can i change it to dd.mm.yyyy?
Hi Marius,
Just Put this in dimension with Date field for which you want to display different format.
Date(Dato,'DD.MM.YYYY')
It works , as I checked.
If it still doesn't work for you then kindly attach the qvw.
In Script,
Date(Date#(Dato,'DD,MM.YYYY'),'DD.MM.YYYY') As Dato
hi,
go to chart property->
Date(Date,'DD.MM.YYYY')
In your Pivot Table, Call your date as an expression (eg. =Date)
Go to Properties->Number Tab->Select Date(Left side)->then select 'Date' in Number Format Settings->Specify the format you require.
Now the date/dato displays two places.. I also tried to remove the "Dato" dimension but then i cant move the "Dato" expression under "Måned"
It does not work.. now I get "//Error in calc..." in every date cell.
hi ,
send a test file of qvw.
Regards
Vimlesh
Hi,
Try like this in script
Load
*,
Date(Date#(DateFieldName,'DD,MM.YYYY'),'DD.MM.YYYY') AS Date_Format
FROM DataSource;
Now you can use this field as dimension in the chart.
Regards,
Jagan.
hi ,
clear one more thing your date is data source should be in date format not in text.
if you will use num(date) function then your date should be in number format.
if it is not showing in number then go to script and use makedate function to convert Text date format
prefer attached QVW file
Regards
Vimlesh
Hi Marius,
Just Put this in dimension with Date field for which you want to display different format.
Date(Dato,'DD.MM.YYYY')
It works , as I checked.
If it still doesn't work for you then kindly attach the qvw.