Compare two Years which each other

[Anonymous]

Hi!

I'm very new to QlikView and i would now like to Compare Data of one Month in a Fiscal Year with the same Month one year before.

If there is any other selection this should also be considered.

How can i do that?

[Janneke]

Hi Andreas,

You can use set analysis in two expressions:

=sum({$<Month={SelectedMonth},Year={ThisYear}>Value)

=sum({$<Month={SelectedMonth},Year={PreviousYear}>Value)

Greetings, Janneke.

[awhitfield]

What date fields do you have in your qvw?

Andy

[#4]

in modifer

=sum({$1<month={jan}>}amount)

=sumn({1<month={jan}>amount)

[Anonymous]

Hi,

i have the following Fields in my QVW

CalenderMonth,
CalenderYear,
CalenderYearmonth,
FiscalYear,
FiscalMonth,
FiscalYearMonth,
PrevFY,
PrevCalenderYear,
NameofMonth,
Workingdays

[Janneke]

Hi Andreas,

Your expression for the month this fiscal year could be:

=sum({$<FiscalYear={2015},FiscalMonth={02}>}[data_to_compare])

Your expression for the month last fiscal year could be:

=sum({$<FiscalYear={2014},FiscalMonth={02}>}[data_to_compare])

Option: You can have the years you want to compare in variables. Then, instead of {2015} and {2014} you can use {'$(variableYear)'} and {'$(variableYearMinus1)'} or {'$(=variableYear-1)'}.

Good luck!

Janneke.

[Peter_Cammaert]

Create a straight table with one dimension = FiscalMonth and two expressions like:

=sum({<FiscalYear = {$(=Max(FiscalYear))}>} Data)

=sum({<FiscalYear = {$(=Max(FiscalYear) - 1)}>} Data)

Replace the dummy field Data in the examples with the one you want to aggregate.

Best,

Peter

[sagarkharpude]

Previous Year

Sum({<Year = {'$(=Max(Year)-1)'},Month = {'$(=Max(Month))'}>}Value)        

And

Current Year

Sum({<Year = {'$(=Max(Year))'},Month = {'$(=Max(Month))'}>}Value)