Straight Table Data Filter Issue

[250575qlik]

I have a Straight table /dataset as below

SalesRep	Category	Sum(Sales)
A	TV	100
A	Laptop	200
B	Laptop	300
B	Desktop	500
C	Laptop	450

Since the sales Rep 'A' Sold the Category TV ,I want to exclude Sales Rep 'A' from the chart/Sheet.

The result should be as follows

SalesRep	Category	Sum(Sales)
B	Laptop	300
B	Desktop	500
C	Laptop	450

Please help

[miskinmaz]

Sum({<Category-={'TV'}>}Sales)

[Vegar · Accepted solution]

You need to use  SET and E() to exclude the TV selling agents. (See attached QVW)

sum({<SalesRep = E({<Category={'TV'}>}) >} Sales)