Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Giselle100
Contributor III
Contributor III

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])))))

Labels (2)
0 Replies