Straight Table Dimension Limiting

[neerajthakur]

Hi, I have a dimension in and measure and data gets filtered out, but when clicking on search option beside the dimension all the values of that field is visible I want to limit to only those which satisfies the measure or turn off the search option, cannot use only as same value can be present for two or more dimension in other fields.

[RafaelBarrios]

Hi @neerajthakur 

I think you will need to use an IF condition in the dimension to do this.

also, you could use

aggr(only({< someSetAnalysisConditions>} dimiension_field),dimiension_field)

https://community.qlik.com/t5/New-to-Qlik-Sense/Dinamyc-selection-on-a-filter-in-Qlik-Sense/m-p/1988...

but I would go for the IF.

Hope this works for you 

best,