topic set analysis error? in QlikView

set analysis error?

Wed, 01 Dec 2010 11:50:49 GMT

Hi everyone,

I have created an exprssion where I want a row to show January's figures regardless of the month selection. the only reason that this should change is if the year changes. therefore using set analysis I have created the expression:

sum({<Master_Calendar_MonthYear={"=$(=yearstart(Master_Calendar_MonthYear))"}>} Value)


This however, doesn;t seem to work. If I do a simple yearstart(Master_Calendar_MonthYear) in a text box it gives the correct answer so I'ma little puzzled why it isn't working for the set analysis.
Can anyone see what is missing?
Thanks</body>

set analysis error?

googel84 — Wed, 01 Dec 2010 16:42:18 GMT

I would try with

sum({<Master_Calendar_MonthYear = {'$(=yearstart(Master_Calendar_MonthYear))'}>}Value)

I cancelled an "=" sign and used single quote instead of double.

Hope it helps.

set analysis error?

Wed, 01 Dec 2010 16:58:19 GMT

That just makes the table show no data at all unfortunately. thanks for the suggestion though.