topic Re: Year format in QlikView

Year format

nareshthavidishetty — Tue, 19 Jan 2016 13:01:30 GMT

I have year format as 5024 ,5048,5049.I need to convert it as 'YYYY'.

Re: Year format

sunny_talwar — Tue, 19 Jan 2016 13:02:22 GMT

Where did it come from? Outside QlikView what would 5024 correspond to in YYYY?

Re: Year format

Anonymous — Tue, 19 Jan 2016 13:06:10 GMT

Did you try with Year()??

Re: Year format

Chanty4u — Tue, 19 Jan 2016 13:08:45 GMT

try year()

if not chk below

On Format Codes for Numbers and Dates

Re: Year format

nareshthavidishetty — Tue, 19 Jan 2016 14:24:56 GMT

Hi it came from AS400

Logic used in qlikview

year(FCST) as Year it gives 5024...

Re: Year format

sunny_talwar — Tue, 19 Jan 2016 14:26:34 GMT

Can you share the data within FCST?

What do you see when you do

LOAD FCST

FROM Source

Re: Year format

nareshthavidishetty — Tue, 19 Jan 2016 15:09:57 GMT

Am getting like

1141209

1141210

1141211

1141212.............

Re: Year format

HirisH_V7 — Tue, 19 Jan 2016 15:10:35 GMT

Hi,

Check this ,

Get the Dates Right

Post Sample data.!

-Hirish

Re: Year format

nareshthavidishetty — Tue, 19 Jan 2016 15:13:17 GMT

Expression used to covert FCFSDT into date format

Date(AddYears(Date(Date#('19'&Right(FCFSDT,6),'YYYYMMDD'),'DD/MM/YYYY'),100*Left(FCFSDT,1)),'M/D/YYYY') as webAppSubmittedDate

Re: Year format

nareshthavidishetty — Tue, 19 Jan 2016 15:28:16 GMT

I have converted this into date year but am facing the issue as below.I need to remove duplicates

Re: Year format

sunny_talwar — Tue, 19 Jan 2016 15:29:43 GMT

Try this:

Year(Date(AddYears(Date(Date#('19' & Right(FCFSDT,6),'YYYYMMDD'), 'DD/MM/YYYY'), 100 * Left(FCFSDT,1)), 'M/D/YYYY')) as Year

Re: Year format

Peter_Cammaert — Tue, 19 Jan 2016 15:47:19 GMT

Maybe a bit simpler:

...Year(Date#(19000000+FCFSDT, 'YYYYMMDD')) AS Year, ...