Qlikview - dynamic set expression to disregard all calendar (or any other dimension) selections

qlikview_set_expression_to_ignore_dimension_selections

// Credit to http://community.qlikview.com/blogs/qlikviewdesignblog/2013/11/18/dollar-expansions

// define variable which will pull/contatenate all members of dimension to disregard
Set vClearCalendar = "='[' & Concat({1<$Table={'Calendar'}>} $Field, ']=,[') & ']=' ";

// if you want to exclude some, for example Year:
Set vClearCalendar = "='[' & Concat({1<$Table={'Calendar'}, $Field-={'Year'}>} $Field, ']=,[') & ']='  ";

//this is how set expression will look like
// Sum ({$<$(vClearCalendar)>} Amount)

// it will be evaluated to something like this and it will ignore all selections for Calendar dimension:
// Sum ({$<[Date]=,[Day]=,[Month]=,[Week]=,[Year]=>} Amount)