Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sanketkhunte
Creator II
Creator II

YoYs : Year over Year Analalysi Qlikview 10

Hi ,

In my current dashboard, there is one YoY analysis chart which has some issues while displaying data for current Year.

Details -:

1. Dashboard pulling data from 2009 - (2009,2010,2011,2012,2013 & Current year upto today).

2. In YoY Chart i am using below Expression with Set analysis -:

=(sum({<Date = {">=$(=MonthStart(Max(Date), -12))<=$(=MonthEnd(Max(Date),-1))"},DATE=,Year=,Month=>}sales)

-sum({<Date = {">=$(=MonthStart(Max(Date), -24))<=$(=MonthEnd(Max(Date),-13))"},DATE=,Year=,Month=>}sales))

Above expression working fine for previous years but when dashboard user select Current Year from Year filter (i.e. 2014) logicaly , YoY chart should display data only upto AUGUST - 2014 however it shows data for all 12 months ( from previous years ) as well.

My requirement is : Whenever user select Year as Current Year , YoY chart should show data up

Jan 2014 to August - 2014 .

Your inputs on this really appreciating to us.

Thanks

Sanket

1 Reply
Gysbert_Wassenaar

Use YearStart(max(Date)) instead of MonthStart(Max(Date),-12) if you want to calculate from the start of the year instead of from 12 months earlier. For the previous year use YearStart(Max(Date),-1)


talk is cheap, supply exceeds demand