topic exclude numerous field selections in set analysis in QlikView

exclude numerous field selections in set analysis

zagzebski — Thu, 13 Aug 2015 18:37:09 GMT

Is there a way to exclude all fields selections except for a few? I know I could call out each field in the expression (or a variable with those fields) , but this would mean naming over 100 fields that are potential selections by a user in the UI.

I have an expression where I want only date fields to be considered in the expression and all others that may be filtered to be excluded in the expression.

Thanks in advance,

Steve

Re: exclude numerous field selections in set analysis

maxgro — Thu, 13 Aug 2015 19:42:32 GMT

try here

Ignore all selections except some specific fields using Set Analysis

Re: exclude numerous field selections in set analysis

Thu, 13 Aug 2015 20:08:41 GMT

You need construct your SET expression with $Field system field.

Please follow above resource document for more info.