topic set analysis within dollar bracket expansion? possible?! in QlikView

set analysis within dollar bracket expansion? possible?!

Thu, 23 Aug 2012 09:53:25 GMT

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

Re: set analysis within dollar bracket expansion? possible?!

masha-ecraft — Thu, 23 Aug 2012 10:03:46 GMT

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.

Re: set analysis within dollar bracket expansion? possible?!

Thu, 23 Aug 2012 10:07:12 GMT

True,

Although I only need it to be evaluated once as it is going off what the current month is.