2 Replies Latest reply: May 17, 2018 5:55 PM by Joey Lake RSS

    Create master measure calculating a selection of data

    Joey Lake

      Hello again Qlik Community,


      I have a set of data, for this exercise I'll identify a real small example:


      AccountSharing StatusRevenue
      NicejeansNot Sharing$1009.16
      SmallpocketNot Sharing$32.12


      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).


      I appreciate any help!