topic Trim, PurgeChar problem ? in QlikView

Trim, PurgeChar problem ?

Wed, 16 Jun 2010 14:20:53 GMT

hi;

in my list of birthday fields looks like ( 01/01/1980 12:00:00 AM ) but i just want to see ( 01/01/1980 ) because i have to use this format.

i use purgechar and trim in edit script before reload but it does not work. some points i did not catch ?

Thanks in advence

Trim, PurgeChar problem ?

Wed, 16 Jun 2010 16:46:45 GMT

It looks like this is a TIMESTAMP field and not a string, so try Date(YourDateFieldName,'DD/MM/YYYY') instead of purge/trim.

Trim, PurgeChar problem ?

Wed, 16 Jun 2010 16:55:38 GMT

Hi,

try this in your script .it should work.

load left(01/01/1980 12:00:00 AM,index(01/01/1980 12:00:00 AM,' ')) as column;

thanks

Trim, PurgeChar problem ?

Thu, 17 Jun 2010 08:47:30 GMT

Hi;

Thanks for responses...

I try both scripts but it does not work immediately. Default field in the database is BIRTH_DATE and format looks like "01/01/1980 12:00:00 AM" I'd like DD/MM/YYYY(e.g. 01/01/1980) and i dont want to see timestamp. Those scripts give me numbers with unknown format (e.g. 0040-01-01)

I am so confused about this problem...

I am just waiting your ideas.

Thanks

Trim, PurgeChar problem ?

kji — Thu, 17 Jun 2010 09:08:22 GMT

If its just a display issue you should load the field as normal, and then set the display number format to use "Date", this can be done in document properties, number tab, or the number tab of the object displaying the field.

Trim, PurgeChar problem ?

Thu, 17 Jun 2010 09:24:46 GMT

Thank you...

It works troubleless