topic Re: Filtering records in chart based on expression value in QlikView

Filtering records in chart based on expression value

miranrai — Thu, 18 Jun 2015 09:51:25 GMT

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

c 20

b 2

d 12

d 10

Thanks in advance.

Thu, 18 Jun 2015 09:55:49 GMT

PFA

vardhancse — Thu, 18 Jun 2015 09:57:07 GMT

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

settu_periasamy — Thu, 18 Jun 2015 10:00:16 GMT

Try

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

ajaykumar1 — Thu, 18 Jun 2015 10:01:01 GMT

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