Current time selection VS previous year

[benjamins]

Hey guys,

I have the following requirement:

I want to make a deliberate selection in my calender within a single year. So say March to July or Weeks 17 to 40, or 12th to end of month in June, Octobre and November. So with the complete flexibility offered.

I then want to compare this selection against the same selection in the previous year.

Is that possible at all?

Thank you so much!

[Gysbert_Wassenaar · Accepted solution]

Yes, see for example this document: QlikView App: Set Analysis - Prior Period Comparison and this blog post: Year-over-Year Comparisons

[suresh_rawat]

Hi,

Yes it is possible.

Use this Expression.

Current Year = sum( {$<year = {$(=Max(year))}>} Data)

Previous Year = sum( {$<year = {$(=Max(year)-1)}>} Data)

Regards

Suresh Rawat