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
      CoolshortsSharing$435.76
      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!