Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
estherds
New Contributor III

Date Formatt in Qlikview

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

Tags (2)
6 Replies
vishsaggi
Esteemed Contributor III

Re: Date Formatt in Qlikview

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

Khan_Mohammed
Honored Contributor II

Re: Date Formatt in Qlikview

Maybe...?

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

Venkatchoudary
New Contributor III

Re: Date Formatt in Qlikview

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.

Re: Date Formatt in Qlikview

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
Contributor

Re: Date Formatt in Qlikview

Hi,

you can try this converting number into date purpose

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

HirisH_V7
Honored Contributor

Re: Date Formatt in Qlikview

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.

HirisH
“Aspire to Inspire before we Expire!”