The sum of the values not assigned to the related table

[qlikeers]

Hi!

I have two related tables:

Sales:

%Key	Date	Sales
a	2021-10-01	1200
b	2021-10-15	300
...	...	...

Dim:

%Key	Data1
a	T
c	T
...	...

"Data1" always takes the value "T".

How (without working on tables, e.g. left join) do sum of sales from table "Sales", for all rows, where there is no data assigned from table "Dim"?

=sum( {<

[Data1] -= {'T'}

>}[Sales])

Didn't work.

[Or · Accepted solution]

Sum(if(isnull(Data1),Sales) should work. You could also write that into search analysis if you needed to, I suppose. There's more than a few posts here on the community site about set analysis and null values so you can search up different solutions and pick the one you like.

[qlikeers]

Ok, thanks!