Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
PFA
sum({<B={">=20"}>}B)
Try
=sum({<B={">=20"}>}B)
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