Date Formatt in Qlikview

[Anonymous]

Hello,

I was wondering if I could get some help please.

The date in my pivot table should display 11/10/17 but instead I am getting the below result.

Kind regards,

Esther

[vishsaggi]

what is your source data date format? Try using Num(Floor(YourdateField))  OR Date(Date#(yourdatefield, 'yoursourcedateformathere'))

[MK9885]

Maybe...?

Date#( FieldName, 'MM/DD/YYYY') as Date

[Venkatchoudary]

If you could share your data field or qvw file, makes easy to help you.

1. If that field lies in expression then, go to chart properties--.>Numbers--> select date format for specific expression.

2. if that lies in dimension then make it as Date(field name).

Hope It works.

[MarcoWedel]

Hi,

'1033176:00:00' is the result of formatting the date '11/10/2017' to show only hours:minutes:seconds.

Either change the number format in your pivot table or use Date(YourValue) to format your value as date.

hope this helps

regards

Marco

[ravikumar_iyana]

Hi,

you can try this converting number into date purpose

Date(Num#(from_date,'####()'), 'dd/mm/yyyy') as newDate

[HirisH_V7]

The Field your referring in screen shot is Time not a date i believe.

Please check your data source and check which field are you looking to convert.