topic Re: non associated fields in Multibox in QlikView

non associated fields in Multibox

Wed, 02 Aug 2017 07:34:10 GMT

Hi All,

Suppose I have a multibox with 2 fields for selection: Field1 and Field2. If I make a selection in Field1, all associated values in Field2 will be displayed in white in Field2 dropdown and the non associated values will be grey. Now suppose that based on my selection in Field1, there exists only a single associated (white) value in field2. Currently, the multibox will display the single associated value in Field2.

Is there any way to not show non associated values in the multibox

If there are multiple records for field2 based on my selection of field1 it should not display as attached

Thanks inAdvance.

Re: non associated fields in Multibox

PrashantSangle — Wed, 02 Aug 2017 07:43:05 GMT

try belowexpression in multibox

aggr(fieldName,fieldName)

Regards

Re: non associated fields in Multibox

tresB — Wed, 02 Aug 2017 07:44:36 GMT

Presentation tab->Hide Excluded

Re: non associated fields in Multibox

Wed, 02 Aug 2017 12:35:09 GMT

Thanks for the information Both The answers helped me to achieve.