topic Re: Current time selection VS previous year in QlikView

Current time selection VS previous year

benjamins — Thu, 30 Oct 2014 10:17:33 GMT

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!

Re: Current time selection VS previous year

Gysbert_Wassenaar — Thu, 30 Oct 2014 10:24:39 GMT

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

Re: Current time selection VS previous year

suresh_rawat — Thu, 30 Oct 2014 10:25:40 GMT

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