Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks
I don't see why it should not work. You only have to remember, that those dollar bracket expressions are evaluated only once in the beginnig of the chart calculation, they are not dynamic wihin a chart.
True,
Although I only need it to be evaluated once as it is going off what the current month is.