Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Hi,
Please try calculated dimesnion.

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

Thanks!

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