topic Re: Number Presentation in QlikView

Number Presentation

emteam162 — Tue, 21 May 2013 09:59:24 GMT

Hi,

I have created a chart Dynamic and i have on field format date "YYYY-MM-DD" and i want to have this format "DD/MM/YYYY"

there is a way to do that knowing i remove and i add the field to chart dynamic

i try this Settings ==> Document Prop ==>Number ==> Number Format Settings ==> Date"DD/MM/YYYY"

but doesn't work ?

i use QV 11 SR2

Many thanks for your help

Best Regards,

Emteam

Re: Number Presentation

sushil353 — Tue, 21 May 2013 10:00:52 GMT

use date function

DATE(field,'DD/MM/YYYY')

HTH

Sushil

Re: Number Presentation

Tue, 21 May 2013 10:02:02 GMT

date(date#(fieldname,'YYYY-MM-DD'),'DD/MM/YYYY')

Re: Number Presentation

kumarnatarajan — Tue, 21 May 2013 10:02:54 GMT

Hi,

1. Try this one.

Ex: Date(DateFieldName,'DD/MM/YYYY')

2. if you have string format use this one. This syntex convert string format to Date format

Ex: Date(Date#(DateFieldName,'DD-MM-YYYY'),'DD/MM/YYYY')

Re: Number Presentation

er_mohit — Tue, 21 May 2013 10:05:06 GMT

in load script where you use your datefield

try this in that load script

date(date#(datefield,'YYYY-MM-DD'),'DD/MM/YYYY') AS DateField

the date# function gives you same ormat and Date function gives you that format which you want

Hope it helps

Re: Number Presentation

Gysbert_Wassenaar — Tue, 21 May 2013 10:06:38 GMT

The document properties set the default date format. If the value already has a format then it will keep that format. You can give the date the correct format in the script. Maybe you can specify the wanted format on the Number tab of the chart. If not you'll have to use the date() function to change the format: date(MyDateField, 'DD/MM/YYYY')

Re: Number Presentation

emteam162 — Tue, 21 May 2013 10:06:49 GMT

Hi All,

Thanks for your answer

but in my case i have 40 field type date their format "YYYY-MM-DD"

Many thanks

Best Regards,

Emteam

Re: Number Presentation

kumarnatarajan — Tue, 21 May 2013 10:09:55 GMT

Hi,

Send sample data. What types of date you have

Re: Number Presentation

emteam162 — Tue, 21 May 2013 10:14:09 GMT

Hi Gysbert Wassenaar,

Thanks for your answer

but in my case i have 40 field type date their format "YYYY-MM-DD"

Many thanks

Best Regards,

Emteam

Re: Number Presentation

nizamsha — Tue, 21 May 2013 10:21:57 GMT

DATE(FIELDNAME,'DD/MM/YYYY')

DATE#(FIELDNAME,'DD/MM/YYYY')

Re: Number Presentation

Gysbert_Wassenaar — Tue, 21 May 2013 10:54:27 GMT

Then you may have to override the date format in the script for those 40 fields. Make sure you set the DateFormat variable correctly: SET DateFormat='DD/MM/YYYY';

Or just be lazy and live with the YYYY-MM-DD format.

Re: Number Presentation

emteam162 — Tue, 21 May 2013 15:00:35 GMT

Hi,

In my Script i have SET DateFormat='DD/MM/YYYY';

But doesn't working

I don't have no choose except to do date(FieldName,'DD/MM/YYYY')

Many thanks

Best Regards,

Emteam