topic Re: changing format in QlikView

changing format

Thu, 17 Jul 2014 11:04:42 GMT

Date
01.07.2014
02.07.2014
07-03-2014
07-04-2014
05-07-2014
06-07-2014
07.07.2014
07.08.2014

this is for july month (IN DD.MM.YYYY , MM-DD-YYYY , DD-MM-YYYY , MM.DD.YYYY FORMAT)and i want it to convert into 'DD/MM/YYYY' FORMAT

Re: changing format

maleksafa — Thu, 17 Jul 2014 11:09:16 GMT

if you want to apply it on all the dashboard, you can change the date format from the Main Page in the script.

SET DateFormat='DD/MMM/YYYY';

Re: changing format

Anonymous — Thu, 17 Jul 2014 11:10:42 GMT

Date(Replace([DateFieldName]),'.','/'),'DD/MM/YYYY')

Re: changing format

er_mohit — Thu, 17 Jul 2014 11:12:45 GMT

Can't be possible in qlikview in technical sound. Qlikview reads only one format at time and rest of one treated as string from.

so, in your case there's in single date field having different format used. so, try to use a single format in your database and call it in qlikview . then you can use that date field in any format which you want.

hope you understand

Regards

Mohit

Re: changing format

ashfaq_haseeb — Thu, 17 Jul 2014 11:15:22 GMT

Hi,

Look at alt function.

Regards

ASHFAQ

Re: Re: changing format

Anonymous — Thu, 17 Jul 2014 11:16:21 GMT

Use the alt() function as described in this pdf

http://community.qlik.com/servlet/JiveServlet/previewBody/3102-102-4-4191/DateFields-TechBrief-US_v2.pdf

I have pasted this example in from the pdf.

Alt( Timestamp#(MixDate,'M/D/YYYY h:mm tt'),

Date#(MixDate,'M/D/YYYY'),

Date#(MixDate,'D/M/YYYY'),

Date#(MixDate,'YYYYMMDD'),

Date#(MixDate,'DD.MM.YYYY'),

Date#(MixDate'YYYY-MM-DD')

) as MixDate

Re: changing format

MK_QSL — Thu, 17 Jul 2014 11:17:09 GMT

QlikView can't read two same format at a time...

Consider that you have

01/07/2014 and 07/01/2014....
QlikView consider it as 1st July and 7th January....

Re: changing format

Thu, 17 Jul 2014 11:18:13 GMT

i know but now it can't be done on database end