topic Re: adding FY suffix to year field in QlikView

adding FY suffix to year field

Wed, 20 May 2015 13:56:05 GMT

Hi I have the following field in my script to work out the fiscal year. What I want to do is add a suffix of 'FY' to the years so for instance they would read 2013 FY. I believe this is achieved using the dual function but cant quite get it to work. My field is :

,If(Month($(vDateField)) >= 10, Year($(vDateField)) + 1, Year($(vDateField))) as FISCAL_YEAR

Thanks

Re: adding FY suffix to year field

Wed, 20 May 2015 14:01:55 GMT

Hi Sid,

if you need it as a dual, just append the text to the first parameter and the base number in the second.

Dual(If(Month($(vDateField)) >= 10, Year($(vDateField)) + 1, Year($(vDateField))) & ' FY',

If(Month($(vDateField)) >= 10, Year($(vDateField)) + 1, Year($(vDateField)))) AS FISCAL_YEAR

hope that helps

Joe

Re: adding FY suffix to year field

Wed, 20 May 2015 14:30:06 GMT

Thanks Joe it worked perfectly.

Re: adding FY suffix to year field

Wed, 20 May 2015 14:39:01 GMT

no worries glad to help