topic Re: Fiscal year selection(Set Analysis) in QlikView

Fiscal year selection(Set Analysis)

ajaysingh29 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Need your help, I have data in which I want to display Fiscal year data based up on selection.

If I select 2016 It should display data from Oct'15-Sep'16, if 2015 selected from Oct'14-Sep'15..same for 2017....

Thank you in advance.

Re: Fiscal year selection(Set Analysis)

MK_QSL — Fri, 13 Jan 2017 08:41:06 GMT

Use below link to create Fiscal Year and Fiscal Month..

Fiscal Year‌

Fiscal and Standard Calendar generation

Re: Fiscal year selection(Set Analysis)

ajaysingh29 — Fri, 13 Jan 2017 10:45:39 GMT

Manish, thanks for your reply, can you please help me out with this code, I don’t have any date field & master calendar in app. It’s just year & month fields,with reference to Fiscal Year document I tried like this in code:

Set vFM = 10 ;

LOAD Year,

Month,

dual(Year-1&'/'&Year,Year)as Fyear,

dual(Month,Month) as Fmonth,

Year+if(Month>='$(VFM)',1,0) as fYear,

Mod(Month-'$(vFM)',12)+1 as fmonth,

Field1,

Field2,

Field3,

Field4

FROM

.....

output is:

Many thanks. !