How to calculate previous year data

[abc_18]

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.

[Gysbert_Wassenaar]

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.

[sunny_talwar]

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.

[abc_18]

Hi Sunny,

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

Date I have linked with master calendar .

[sunny_talwar]

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

[abc_18]

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.