topic Re: Fiscal Year Set Analysis Previous year in QlikView

Fiscal Year Set Analysis Previous year

Fri, 20 Sep 2013 11:47:33 GMT

hi i have the following format

2012-2013 on fiscal year

i would like to create a set analysis expression based on fiscal year

i have tried the following without success ;

sum( { $<FiscalYear = Year={"$(=max(Year)-1 & '-' & max(Year)-2"))}>}OrderAmt

any help is greatly appreciated.

Best

Brad

Re: Fiscal Year Set Analysis Previous year

abeyphilip — Fri, 20 Sep 2013 13:00:03 GMT

Hi,

Check if this help:

sum({<Year={"$(=$(vYear1)&'-'&$(vYear2))"} >}OrderAmt)

with two variables:

vYear1 = max(Year)-1

vYear2 = max(Year)-2

Regards,

Abey

Re: Fiscal Year Set Analysis Previous year

pgrenier — Fri, 20 Sep 2013 13:16:35 GMT

Hello Bradley,

I believe this might come in handy:

Sum({<FiscalYear={"=(Max(Year)-1)&'-'&(Max(Year)-2)"}>} OrderAmt)

Cheers,

Philippe

Re: Fiscal Year Set Analysis Previous year

Fri, 20 Sep 2013 14:24:31 GMT

Thank you for your advice.

unfortunately i need a statement that is dynamic so that is i can get the previous calender year as well.

for example if i if i choose 2013-2014 i would like to see 2012 -2013 in the column beside 2013-2014.

example

Sum({<FiscalYear={"=(Max(Year)-1)&'-'&(Max(Year)-2)"}>} OrderAmt)

Sum({<FiscalYear={"=(Max(Year)-2)&'-'&(Max(Year)-3)"}>} OrderAmt)

i have tried with increasing minus values to 1 in the statement but to no avail.

any tips

Best,

Bradley

Re: Fiscal Year Set Analysis Previous year

pgrenier — Fri, 20 Sep 2013 15:18:32 GMT

I see,

I believe you shall have to parse the contents of the current selected FiscalYear, and work with that. Would you mind giving this statement a try?

Sum({<FiscalYear={"=(Left(FiscalYear, 4)-1)&'-'&Left(FiscalYear, 4)"}>} OrderAmt)

Cheers,

Philippe

Re: Fiscal Year Set Analysis Previous year

chematos — Fri, 20 Sep 2013 20:56:38 GMT

With $(=max(Year)-1 & '-' & max(Year)-2), don't you get 2012-2011 instead of 2012-2013?

Also, I think you need simple quotes to get '2012-2013' and compare with FiscalYear

try this:

sum( { $<FiscalYear ={'$(=(max(Year)-1) & '-' & max(Year))'}>}OrderAmt)

Hope this helps

Regards

Re: Fiscal Year Set Analysis Previous year

Clever_Anjos — Fri, 20 Sep 2013 21:12:29 GMT

I think

sum( { $<FiscalYear = Year={"$(=max(Year)-2 & '-' & max(Year)-1"))}>}OrderAmt)

should be the correct

Re: Fiscal Year Set Analysis Previous year

anna_elle — Thu, 24 Jan 2019 15:39:34 GMT

Hey Philipe,

I tryed all your smart suggestions, without success.

The issue is that once I set the quotas, the funktions are recognised as a string:

I created the fiscal year by using the Funktion "yearName" , the format of the output is a date and is shown as 2012-2013.

Do you know what the solution could be?

Many Thanks,

Anns