Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Hauglaen
Contributor II
Contributor II

Filter on one of two measures

Hi,

I only want to display products sold in one specific sales channel in a table.

The income for product 4 and 5  is filtered out by sales channel in a set expression. The problem is that production cost does not have a sales channel dimension.

Is it possible to only display product 1, 2 and 3 when the right products are filtered out by Income?

ProductDepartmentIncomeProduction cost
110010050
21207525
31009040
4100 30
5120 70

I have over 40 000 products.

Thanks!

2 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi,
Please try calculated dimesnion.

if(Sum(income)>0,Product) as Product
Hauglaen
Contributor II
Contributor II
Author

Thanks!

It worked with: If(Aggr(Sum(Income)<>0,Product),Product)