Does anyone know why subsetting a created variable doesn't work?
Hey Guys ,
Im struggling to subset a dimension, any thoughts or ideas?
[SC]:
Load
[RESPID],
// [PID],
[WGT],
Month,
[Location],
[Age],
// [Occupation],
// [Industry],
[Employment],
[Household v1],
[HH Income],
// [Education],
[Quarter]
From [lib://A (qlik1)/SC.xlsx]
(ooxml, embedded labels, table is [SC]);
FOR vMonth = 0 to 11
MATMonthYear:
LOAD
[Month],
Date(AddMonths([Month], $(vMonth)),'$(vMonthFormat)') as [MATMonthYear]
RESIDENT SC
WHERE AddMonths([Month], $(vMonth)) < '43222'
;
next
I want to create a subset of the dimension MATMonthYear by doing the following:
Load
if(Match([MATMonthYear],'May-2010','May-2011','May-2012','May-2013','May-2014','May-2015','May-2016','May-2017','May-2018'),[MATMonthYear],null()) as Yeartodate;
but i keep getting an error saying it doesnt exist.
