force inner join in set analysis/expression

[#1]

Hi,

I have two tables, vendour and Supplier. Both tables are joined through sourcerowid and its an outer join.

When I create a chart with country as dimension, sum(vendorSpend ), sum(SupplierSpend)

I get some rows where either of vendourspend or supplierspend is zero/null. What I want is an inner join so that I only see the rows where both of them exist

My question is, how can I force innerjoin through set analysis

Shah

[senpradip007]

Can you upload sample qvw?

[stigchel]

Something like this?

Sum({<vendorSpend={'>0'}> * <SupplierSpend={'>0'}>} vendorSpend)

and

Sum({<vendorSpend={'>0'}> * <SupplierSpend={'>0'}>} SupplierSpend)