Set analysis using getfieldselection

[#1]

I am trying to get set analsyis to give me all the values less than the monenddate selected in the attached example but the formula is not quite right.

Can any one fix this please.

=

sum({$<[MonthendDate]={'=<$(GetFieldSelections(MonthendDate))'}>} Value)

[Miguel_Angel_Baeyens]

Hello,

I recommend you to check this one of my favorites http://community.qlik.com/forums/p/23950/91539.aspx

Bear in mind that functions in set analysis require an "=" sign within dollar expression like

sum({$<[MonthendDate]={'=<$(=GetFieldSelections(MonthendDate))'}>} Value)

Anyway, take a look at the post above. Is pretty clear to this case.

[#3]

Thanks for the suggestion. I have change it to a variable but I still can not get the set analysis to return values for month end dates before the month end selected. It still shows just the month selected.

Regards

Adrian

[#4 · Accepted solution]

Hi Adrian,

here you go. There was a typo (MonthendDate instead of MonthEndDate) and the expression was not correct.

Good luck!

Rainer

[#5]

Adrian,

here are two modifications. See the example.

Rainer

[#6]

Thank you