topic Re: Compare two Years which each other in QlikView

Compare two Years which each other

Anonymous — Mon, 23 Mar 2015 07:06:58 GMT

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?

Re: Compare two Years which each other

Janneke — Mon, 23 Mar 2015 15:29:19 GMT

Hi Andreas,

You can use set analysis in two expressions:

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

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

Greetings, Janneke.

Re: Compare two Years which each other

awhitfield — Mon, 23 Mar 2015 16:15:57 GMT

What date fields do you have in your qvw?

Andy

Re: Compare two Years which each other

Mon, 23 Mar 2015 17:23:42 GMT

in modifer

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

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

Re: Compare two Years which each other

Anonymous — Tue, 24 Mar 2015 06:38:04 GMT

Hi,

i have the following Fields in my QVW

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

Re: Compare two Years which each other

Janneke — Tue, 24 Mar 2015 08:02:06 GMT

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.

Re: Compare two Years which each other

Peter_Cammaert — Tue, 24 Mar 2015 08:20:23 GMT

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

Re: Compare two Years which each other

sagarkharpude — Tue, 24 Mar 2015 08:26:57 GMT

Previous Year

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

And

Current Year

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