Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

non associated fields in Multibox

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.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: non associated fields in Multibox

Presentation tab->Hide Excluded

3 Replies

Re: non associated fields in Multibox

try belowexpression in multibox

aggr(fieldName,fieldName)

Regards

Regards,
Prashant Sangle
MVP
MVP

Re: non associated fields in Multibox

Presentation tab->Hide Excluded

Not applicable

Re: non associated fields in Multibox

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

Community Browser