Select in field and and best fit option help

[tinkerz1]

Hi,

When I add a button and have multiple 'Select In' fields in the Actions added, Qlikview will find and color green the data it finds, but leave white or grey others, but if you have alternate states it fills out the pivot table with the selected data and include the grey or white data.

I want to say, if all these fields I use in 'Select In' are not returned 'true' then dont post any data.

How can I do that?

Any chance some else has run into this?

Message was edited by: Neil Woodham

[swuehl]

Sorry, not sure if I understand. Could you upload a small sample QVW that demonstrates your issue?

[tinkerz1]

Ok here is my QVW.

Mr B has had no sales of product 2 in Holland but the pivot count of ID is 1.

The button has an alternate state and 3 select in field actions, Salesperson, Country, Product.

The count needs to return zero as the 3 select in fields are 2 = True and 1 = false.

How can I say if all 3 are not true then the pivot count of ID is zero?

[tinkerz1]

Has any one else come across this? Where you need all "Select In fields" to be true in order to work?