topic How ignore a value from a field? in QlikView

How ignore a value from a field?

Fri, 18 Sep 2015 12:45:14 GMT

Hello everyone,

Imagining i have a field "Countries" and there are 3 values (USA, Canada, Brazil).

I want to create a bar chart, that shows values only from Canada and Brazil, and ignore values from USA.

Is it possible to ignore a value and don´t display data in the chart?

Thanks,

Rodrigo

sunny_talwar — Fri, 18 Sep 2015 12:49:08 GMT

Try this in your set analysis:

{<Country = {'Brazil', 'Canada'}>}

sudeepkm — Fri, 18 Sep 2015 13:01:32 GMT

in case you want to display values from all except USA then you can use like below.

{<Country = {"*"} - {"USA"} >}

sasiparupudi1 — Fri, 18 Sep 2015 13:07:47 GMT

{<Country-= {'USA'} >}

satishkurra — Fri, 18 Sep 2015 13:14:13 GMT

Also please take the below inputs

{<Country-= {'USA'} >}

This will work as below

{<Country= {COuntry - 'USA'} >}

{<Country= -{'USA'} >}

This will work as below

{<Country= {*- 'USA'} >}

Both are correct, it depends on the type of requirement you are suppose to display to the business.

Thanks

Satish