topic Set Analysis = Null Values in QlikView

Set Analysis = Null Values

prees959 — Mon, 18 Sep 2017 16:04:28 GMT

Hi,

I am loading in two tables SalesCountryA & SalesCountryB which are linked by Sales Rep.

If I want to sum the the TotalSalesA from SalesCountryA where there is no corresponding sales for that Rep in SalesCountryB - could I do this in set analysis?

Something Like : sum({<sum(TotalSalesB is null>}TotalSalesA)

Thanks for any help!

Phil

Re: Set Analysis = Null Values

Anil_Babu_Samineni — Mon, 18 Sep 2017 16:15:44 GMT

May be these?

sum({<TotalSalesA = {' '}>}TotalSalesA)

sum({<TotalSales = {"=Sum(TotalSalesA) = 0"}> + <TotalSales = {"Sum(TotalSalesA) = ' ' "}>}TotalSalesA)

Sum(If(IsNull(TotalSalesA), TotalSalesA))

Re: Set Analysis = Null Values

aarkay29 — Mon, 18 Sep 2017 16:29:22 GMT

May be something like this

sum({<Rep=e({1<country={'B'}>})>}TotalSalesA)