topic Re: force inner join in set analysis/expression in QlikView

force inner join in set analysis/expression

Fri, 10 Oct 2014 09:47:33 GMT

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

Re: force inner join in set analysis/expression

senpradip007 — Fri, 10 Oct 2014 09:49:39 GMT

Can you upload sample qvw?

Re: force inner join in set analysis/expression

stigchel — Fri, 10 Oct 2014 10:02:22 GMT

Something like this?

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

and

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