I have an expression with set analysis it is ignoring Qlikview filtering (selection of possible values) when a selection is made in the Delayband filter.
Does anyone know of a way I can tell the expression to ignore the delayband choice but acknowledge the resulatant filtering.
I have an expression with set analysis which is on one hand doing what I have asked, it is ignoring the selection made in the Delayband filter but it is also ignoring any other filter that is not expressly chosen.
When selections are made in the filter mulitbox (in green) they select other ones if there is only one option (in white) but these are not added to the current selections box and my expression is ignoring them.
I feel like I am missing something glaringly obvious but have been staring at this so long I thought I'd ask for help. Any ideas would be gratefully appreciated.