Filtering out a specific row

[#1]

Hi,

I have data by regions in a table in column 1. Some of the values in this column are a sum of all the regions and called "All". I would like to filter these values out from the graphs when they are plotted as they make all the other regional data bars look too small. How can I do this?

Secondly, I can only drill down data to 1 level below, but would like to drill down further. Is this possible?

Im using QlikView Personal Edition on my desktop.

Kind regards,

JK

[#2]

See attached.

[#3]

Where did you type the formula? I was typing under properties

[#4]

You type it in Dimensions.

[#5]

Highlighted in blue.

[MayilVahanan]

HI

Used  In expression tab..with set analysis..

Mr.Rebeccad used in dimension.. both give the answer..

Set anaysis gives better performance when compare to if condition.

hope it helps