Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Giselle100
New Contributor II

Comparison between previous season and current season

Hi

Current season is summer 2018.

With below expression, it returns the value for same time LY.

I need it to return  summer 2017.

if(Wildmatch($(ObjectList),'*Week*'), Sum({<Year = {$(vMinYear)}>} [Cls Stk Value]),if(Wildmatch($(ObjectList),'*Month*'), Sum({<Year, $(vClearDates),[SK LDOW No] = P({<[SK Ldom No] -= {$(vMaxLdowLdomPrevious)}>} [SK Ldom No])+{$(vCurrentMonthLdowPrevious)} >} [Cls Stk Value]),if(Wildmatch($(ObjectList),'*Season *'), Sum({<Year, $(vClearDates), [SK LDOW No] = P({<[Numeric Yr Ssn Code] -= {$(vMaxPrevSsnCode)}>}SeasonEndLdow)+{$(vMaxLdowPrevious)} >} [Cls Stk Value]),if(Wildmatch($(ObjectList),'*Year*'), Sum({<Year, $(vClearDates), [SK LDOW No] = P({<Year -= {$(vMinYear)}>}YearEndLdow)+{$(vMaxLdowPrevious)} >} [Cls Stk Value]),Sum({<Year, $(vClearDates), [SK LDOW No] = {$(vMaxLdowPrevious)} >} [Cls Stk Value])))))
+
if(Wildmatch($(ObjectList),'*Week*'), Sum({<Year = {$(vMinYear)}>} [In Trnst Value]),if(Wildmatch($(ObjectList),'*Month*'), Sum({<Year = {$(vMinYear)}, $(vClearDates),[SK LDOW No] = P({<[SK Ldom No] -= {$(vMaxLdowLdomPrevious)}>} [SK Ldom No])+{$(vCurrentMonthLdowPrevious)} >} [In Trnst Value]),if(Wildmatch($(ObjectList),'*Season *'), Sum({<Year = {$(vMinYear)}, $(vClearDates), [SK LDOW No] = P({<[Numeric Yr Ssn Code] -= {$(vMaxPrevSsnCode)}>}SeasonEndLdow)+{$(vMaxLdowPrevious)} >} [In Trnst Value]),if(Wildmatch($(ObjectList),'*Year*'), Sum({<Year = {$(vMinYear)}, $(vClearDates), [SK LDOW No] = P({<Year -= {$(vMinYear)}>}YearEndLdow)+{$(vMaxLdowPrevious)} >} [In Trnst Value]),Sum({<Year = {$(vMinYear)}, $(vClearDates), [SK LDOW No] = {$(vMaxLdowPrevious)} >} [In Trnst Value])))))