Create master measure calculating a selection of data
Hello again Qlik Community,
I have a set of data, for this exercise I'll identify a real small example:
Ultimately, I want to create a Master Measure that sum's up all Revenue of those that are "sharing" and a second one to sum up all Revenue of those "not Sharing".
I've tried things like if([Sharing Status] = 'sharing', sum([Revenue]) but that's not working. I'm sure there's a way to do this, but I just can't figure it out (and my knowledge of expressions is still very limited).