Qlikview function similar to SQUEL In() function Cant use Set analysis because i am not Aggregating
In Sequel if i have a field or dimension [Year}
in the WHERE clase when using SEQUEL I can isolate selected years by typing YEAR IN("2010","2011")
is there a similar function in Qlikview? I can not use Set Analysis because i am not aggrigating the Years i am mearly isolating current year and prior year into on calculated dimension.
for Example, i have the below two variables $(#vCurrYr) and $(#vPrevYr)
if i want to create a calcuated dimenion to included both variables, what formula wil allow me to do that.
If i set =$(#vCurrYr) then i get the current year selection, if i set $(#vPrvYr) then i get the previous year based on my selection on my dashboard.
how can i combine both years to can get two years in a dimension every time the Current Year and the Prior Year?