2 Replies Latest reply: Aug 23, 2012 6:03 AM by Masha Aleinikova RSS

    set analysis within dollar bracket expansion? possible?!

      Hi all,


      Has anyone had any luck using set anlysis within a dollar bracket expansion?  I believe my syntax is correct but it just does not seem to work.


      To get the current month I have to use a flag where currentmonth = Y.  I want to compute the figures before the current month selected.  i did not design the complete dashboard and this is the only flag which signifies what the current month is.


      Therefore my expression is as follows:


      sum({<DateList={"<=$(=only({<InCurrentYear = {'Y'}>}DateList))"}>}[Amount YTD])/AmtValue


      Does anyone see an issue with the syntax?  I have tested out the only({<InCurrentYear = {'Y'}>}DateList) on a text box and it works fine so this shouldnt be the issue.  Does QV allow set analysis within set analysis?


      Appreciate any comments