topic Fiscal Year issue in App Development

Fiscal Year issue

New-Qlik — Wed, 21 Aug 2019 10:55:54 GMT

Hi,

I have an KPI showing sum of Current Fiscal Year Sales .

Fiscal year column have data for FY 2021, FY2020 , FY2019 etc

For KPI I want Sum(Sales) for FY 2019.

I have created a variable

LET vCnFY = PEEK('Fiscal Year', 0 ,'Calendar');

and vCnFY gives me 2019 and KPI shows correct data .

But if I select FY2018 KPI still shows for FY2019. So KPI is not changing with filter selection

KPI expression looks like this : Sum({$<[Fiscal Year ]={'$(vCnFY )'}>}Sales)

I cannot use Max function because it will show me FY2021 data in KPI.

Re: Fiscal Year issue

jonathandienst — Wed, 21 Aug 2019 11:17:48 GMT

>>I cannot use Max function because it will show me FY2021 data in KPI.

Not true. If you select FY2018, then the max, if defined correctly, will be 2018.

Re: Fiscal Year issue

Silambarasan1306 — Wed, 21 Aug 2019 11:24:54 GMT

You can create a variable, vMaxYear - If(GetSelectedCount([Fiscal year])=1,Max([Fiscal year]),$(vCnFY)) Then use this variable in the expression, Sum({$<[Fiscal Year ]={'$(vMaxYear)'}>}Sales)