SUM With condition of one cell is empty

[wcamargo]

Hi all,

I would like to make a sum the columns "Result" if the "Item 1" column is "B" and "Item 2" column is "empty".

In this table example it should return me "30".

Item 1	Item 2	Result
A	X	10
A	X	10
B		10
A	X	10
B		10
B	X	10
A	X	10
B		10

Does anybody know how to help me?

[vinieme12 · Accepted solution]

sum({<Item1={'B'},Item2={"=len(Item2)<1"}>}Result)

read more on set analysis

https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

[wcamargo]

Thanks a lot @vinieme12