Filtering records in chart based on expression value

[miranrai]

I am not sure if i am posting a complete foolish question as its been a long time since i touched Qlikview.

I want to filter a straight table based on the expression value.

Lets say, i have 2 fields A & B. I want to filter records with sum(B)>20.

A  B

a 10

a 20

b 5

b 5

c 20

b 2

d 12

d 10

Thanks in advance.

[#2]

PFA

[vardhancse]

sum({<B={">=20"}>}B)

[settu_periasamy]

Try

=sum({<B={">=20"}>}B)

[ajaykumar1]

Hi,

You want filter sum(B)>20 based on the group by of A?

Is it your needed output:

a--30

d--22

Then expression is : IF(sum(B)>20,sum(B))

Dimension : A

Note : b <20 and c<20

Regards,

Ajay