Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
250575qlik
Contributor
Contributor

Straight Table Data Filter Issue

I have a Straight table /dataset as below

SalesRepCategorySum(Sales)
ATV100
ALaptop200
BLaptop300
BDesktop500
CLaptop450

 

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

SalesRepCategorySum(Sales)
BLaptop300
BDesktop500
CLaptop450

 

Please help

1 Solution

Accepted Solutions
Vegar
Partner
Partner

clipboard_image_0.png

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

clipboard_image_0.png

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

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
miskinmaz
Creator III
Creator III

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

Vegar
Partner
Partner

clipboard_image_0.png

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

clipboard_image_0.png

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

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post