topic Re: Comparison year Vs year before in QlikView

Comparison year Vs year before

ecabanas — Thu, 13 Dec 2012 17:38:40 GMT

I'm using this function to calculate the revenues for present year

=num(Sum({<[YEAR]={$(VYear)}>} Amount))

I would like to know the same but the year before, I put -1 in the variable but it doesn't work, anybody knows why?

=num(Sum({<[YEAR]={$(=(VYear)-1)}>} Amount))

Thank's for your help

CELAMBARASAN — Thu, 13 Dec 2012 17:50:07 GMT

Hi,

Can you tell me what is there in VYear?

MayilVahanan — Thu, 13 Dec 2012 17:55:34 GMT

Try like this

=Sum({<Year = {'$(=max(Year)-1)'}>}Sales) for maximum -1 year

=Sum({<Year = {'$(=max(Year))'}>}Sales) for maximum year

ecabanas — Fri, 14 Dec 2012 07:33:03 GMT

VYear is a variable: =(year)

ecabanas — Fri, 14 Dec 2012 07:35:49 GMT

Doesn't work Mayil...

sujeetsingh — Fri, 14 Dec 2012 07:43:28 GMT

Hi if you are using Master Calender than use following set equation

sum( {$<Year = {$(vLastYear)}>} Sales )

nirav_bhimani — Fri, 14 Dec 2012 08:21:10 GMT

HI,

U can try this. Its working

( sum({<FinancialYear = {"$(=Max(FinancialYear))"} >}Sales) )

( sum({<FinancialYear = {"$(=Max(FinancialYear)-1)"} >}Sales) )

Regards,

Nirav Bhimani

ecabanas — Fri, 14 Dec 2012 08:48:32 GMT

Now it works!!! I load Master Calendar and now it works perfectly

thank you everyone!!!