topic MASTER CALENDER in QlikView

MASTER CALENDER

wonkymeister — Sat, 16 Nov 2024 04:07:44 GMT

Hi all,

i need to generate a 6 character fiscal year to my master calender script (and i'm struggling)

Our fiscal year starts in August - month 8

and the fiscal YEAR label that i'd like to display - 2018/9

so where the current fiscal year short is 2018 and the month is March i need something like

if(Month(MyDate) => 8 and AddYears(Month(MyDate)+1) <8, MyDate & '/' & Right(MyDate,1)+1

to achieve 2018/9 for the current month as the fiscal year

make sense? Any ideas anyone?

thanks in advance

Re: MASTER CALENDER

dplr-rn — Mon, 18 Mar 2019 16:56:56 GMT

Try this

if(Month(OrderDate)>=8
,Year(OrderDate)&'/'&(Num(Right(Year(OrderDate),1))+1)
,Year(AddYears(OrderDate,-1))&'/'&Right(Year(OrderDate),1)) as FiscalYear

Re: MASTER CALENDER

wonkymeister — Thu, 21 Mar 2019 09:35:43 GMT

works a treat, many thanks!