topic How to calculate previous year data in QlikView

How to calculate previous year data

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

HI ,

My expression is

if(DIVISION='PUMA',sum({<FYEAR=>})Value,sum({<Year=>})Value)

if I select Year=2015 then its coming correct, how to get previous year data ie; 2014

Please suggest.

Re: How to calculate previous year data

Gysbert_Wassenaar — Thu, 10 Mar 2016 14:17:30 GMT

Maybe like this:

if(DIVISION='PUMA',sum({<FYEAR={$(=only(FYEAR)-1)}>})Value,sum({<Year={$(=only(Year)-1)}>}>})Value)

If not, please post a small qlikview document that demonstrates the problem.

Re: How to calculate previous year data

sunny_talwar — Thu, 10 Mar 2016 14:19:58 GMT

Are you using this in a chart where you have Year or Date as dimension? If yes, then you might need to use Above()/Below() functions to get this to work.

Re: How to calculate previous year data

abc_18 — Thu, 10 Mar 2016 15:43:57 GMT

Hi Sunny,

Yes I am using this in a chart (Straight Table), and Date is a dimension.

Date I have linked with master calendar .

Re: How to calculate previous year data

sunny_talwar — Thu, 10 Mar 2016 16:50:03 GMT

You will need to use Above()/Below() function to get it to work. Do you have a sample that you can share?

Re: How to calculate previous year data

abc_18 — Fri, 11 Mar 2016 12:01:03 GMT

Hi,

In Master calendar I have two year field one for fiscal year and other for calendar year.(Fyear(Oct-Sep),Year(Jan-Dec))

I need to calculate FY'15, FY 16 Actuals value.(Two Calculated field).so for Intel division we need to use calendar year(Year) and for others division need to use Mater calendar(Fyear).

Likethis:-

if(Division='Intel',sum(value)based on Calendar year,otherwise sum(value) based on fiscal year).

Please help me out in this..sample file is attached.