Where Clausule in expression

[#1]

Hi there,

I want to make a pivot table with dimension MonthYear, with 13 expressions.

4 of the 13 expressions are all for Revenue, sorted in Booking, Prospect, Unlabeled and Extension.

I want an expression like:

sum(Revenue) where Stage = 'Booking'

sum(Revenue) where Stage = 'Prospect'

etc.

How can i do this in Qlikview expressions?

Thanks!

[Gysbert_Wassenaar · Accepted solution]

try:

sum({<Stage={'Booking'}>}Revenue)

sum({<Stage={'Prospect'}>}Revenue)

etc.

[#3]

Doesn't work

[#4]

Excuse me, it does work, can't calculate in the sum... thanks