chain conditions in qlik

[AIShatiLove]

Hi, i have  a table with fields id, type and sum

id	type	sum
1	A	0.1
2	A	0.3
1	B	0.5
2	B	0.2
3	A	1.2
3	B	1.5
4	B	1

so i need  to sum values of type B whose also have A type so my result table should look like this:

id	sum  only B type
1	0.5
2	0.2
3	1.5

[Vegar · Accepted solution]

Try this expression:  sum({<type = {'B'},id = P({<type={'A'}>})>}[sum])

[Kushal_Chawda]

@AIShatiLove  another method is to create a flag in script and use it in set analysis to make expression simpler

Data:
LOAD id, 
     type, 
     sum
FROM Table;

Left Join(Data)
LOAD distinct id,
     'B' as type,
     1 as Flag
Resident Data
where type ='A';

Then use below expression in graph

=sum({<Flag={1}>}Amount)