HI All,
Set analysis can be frustrating sometimes.
I've been trying to tweak a formula to improve storage on a table. Currently I'm extracting the year from a date on the import but i wanted to make this neater by using a variable instead
v_year = a year selectable by the user
v_Quals = date a user qualified , which is set to BKKReg
so originally i was using this for set analysis
=count({$<BKKRegYear={$(v_year)}>} distinct person_id) - this works fine
now BKKRegYear is just = year(BKKReg) which is done on the load script but i wanted to remove this column altogether and just use the column and manipulate it in the set analysis.
I use
=month($(v_Quals)) as a dimension which is working fine
but using
=count({$<year($(v_Quals))={$(v_year)}>} distinct person_id)
throws up an error in expression and gives me no values
Can anyone shed some light on this, this set analysis expression is eluding me
many thanks
