topic Set analysis using getfieldselection in QlikView

Set analysis using getfieldselection

Tue, 19 Jan 2010 12:12:28 GMT

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)

Set analysis using getfieldselection

Miguel_Angel_Baeyens — Tue, 19 Jan 2010 12:59:28 GMT

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.

Set analysis using getfieldselection

Tue, 19 Jan 2010 13:50:28 GMT

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

Set analysis using getfieldselection

Tue, 19 Jan 2010 14:00:03 GMT

Hi Adrian,

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

Good luck!

Rainer

Set analysis using getfieldselection

Tue, 19 Jan 2010 14:14:56 GMT

Adrian,

here are two modifications. See the example.

Rainer

Set analysis using getfieldselection

Tue, 19 Jan 2010 14:28:20 GMT

Thank you