topic Re: Year converstion in QlikView

Year converstion

Srinivas — Mon, 26 Oct 2015 02:06:13 GMT

Hi all,

I have one question, i have one date filed we need to convert to FY-Year like below way:

above FY list box i have converted based on : ='FY'&- Year(YearName(Year, 1, 7)) , but my question is FY came extra, i no need this one

how to remove this one.

Regards

Munna

sunny_talwar — Mon, 26 Oct 2015 02:10:06 GMT

May be something like this this:

=If(Len(Trim(Year(DateField))) > 0, 'FY-'& Year(DateField))

jagan — Mon, 26 Oct 2015 02:45:53 GMT

Hi Srinivas,

I think there are some null values in your Year field, check for that rows, or try below script

LOAD

If(Len(Trim(Year)) > 0, 'FY'&- Year(YearName(Year, 1, 7)))

FROM DataSource;

Regards,

jagan.