Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
new_user30
Contributor II
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
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Contributor II
Contributor II
Author

Thank you Oleg 🙂