Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Lee, you managed to achieve a solution? If not please upload a sample wich demonstrates your problem. English is nor my native language and maybe I'm missing something.