Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
new_user30
New Contributor II

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

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

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.

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

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

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.

View solution in original post

Highlighted
new_user30
New Contributor II

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

Thank you Oleg 🙂