How to filter out just one value from a field in a report?

[new_user30]

Hi,

I have a report  - made of straight table.

It got country field. If I need to see the report for all the countries except "USA", how can filter out that in the report. 

Not in scripts or anything, But if I am analyzing the report in access point, how can I exclude just one value and see the report for rest of the countries.

Thank you.

[Oleg_Troyansky · Accepted solution]

In QlikView, you will need to have a List Box for the field Country, or a Current Selections Box.

Select the Country that you wanted to exclude, then right-click on the selection (either the list box or within the Current Selections Box) and choose "Select Excluded" from the context menu.

Cheers,

Oleg Troyansky

Learn advanced QlikView techniques in my book QlikView Your Business.

[new_user30]

Thank you Oleg 🙂