Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikeers
Creator
Creator

The sum of the values not assigned to the related table

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.

Labels (3)
1 Solution

Accepted Solutions
Or
Champion
Champion

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.

View solution in original post

2 Replies
Or
Champion
Champion

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
Creator
Creator
Author

Ok, thanks!