topic date conversion in QlikView

date conversion

Fri, 10 Jul 2009 08:20:44 GMT

hi, im just a beginner in qlikview.. may i know

i got a column list of date - '200901' refers to Jan 09 or '200805' refers to May 09.

How should I convert to 2 columns '2009' and 'Jan' when qlikview reads the column as '200901' ?

Thanks for your help!!

disqr_rm — Fri, 10 Jul 2009 10:10:41 GMT

You can use string functions like left(date,4) to take the fist 4 digits and create a new field called year, and so on.

So if you have a script like:

LOAD column1 as ListDate from xxx.xls;

You can create additional fields like:

LOAD column1 as ListDate,

left(column1,4) as Year,

right(column1,2) as Month

from xxx.xls;

You get the idea.

Fri, 10 Jul 2009 10:17:37 GMT

thank you!! i got it now.. thanks!!