topic Re: Date Formatt in Qlikview in QlikView

Date Formatt in Qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 13 Nov 2017 20:43:11 GMT

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

MK9885 — Mon, 13 Nov 2017 20:50:03 GMT

Maybe...?

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

Venkatchoudary — Mon, 13 Nov 2017 21:15:28 GMT

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 — Mon, 13 Nov 2017 22:39:52 GMT

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 — Tue, 14 Nov 2017 13:31:08 GMT

Hi,

you can try this converting number into date purpose

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

HirisH_V7 — Tue, 14 Nov 2017 15:15:53 GMT

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.