Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Yes, see for example this document: QlikView App: Set Analysis - Prior Period Comparison and this blog post: Year-over-Year Comparisons
Yes, see for example this document: QlikView App: Set Analysis - Prior Period Comparison and this blog post: Year-over-Year Comparisons
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