topic Re: How to exclude a field value using action in QlikView

How to exclude a field value using action

Tue, 07 Feb 2017 09:48:43 GMT

Hi All,

I have scenario like,

I am navigating from one sheet to another.

Main sheet populating 20 values in region field.

while navigating from Main sheet to another sheet there i need to populate only 18 values in the region field.

How to exclude the field values by using action.

vinieme12 — Tue, 07 Feb 2017 10:12:17 GMT

use an expression based listbox on the other sheets

Aggr(only({< Region = {'list of regions here'} >} Region), Region)

vinieme12 — Tue, 07 Feb 2017 10:13:50 GMT

or please post a sample

Tue, 07 Feb 2017 10:31:39 GMT

Thanks for your reply Vineeth,

I need to show those region values not only in a list box also in table box.

So while navigating from main to that table sheet in the table box also need to exclude those 2 values.

I am preparing the data.