7 Replies Latest reply: Nov 17, 2017 2:51 PM by Sunny Talwar RSS

    Nested Set Modifiers

    Ashley Kuttler

      Hello,

       

      I am new to Qlik Sense, building my first datamodel.

       

      I have a table of transactions with fields 'ITEMTYPE' and 'ENCID' and 'Encounter Total Charges'

       

      For the ITEMTYPE = 'F-C'

      I need the sum('Encounter Total Charges') --->>>Sum({<ITEMTYPE={'F-C'}>}[Encounter Total Charges])

      for Distinct ENCID --->>> Sum(({$<ITEMTYPE = {=DISTINCT ENCID}>}'F-C'>)[Encounter Total Charges])

       

       

      The first expression works but not the second...I cant figure out how to to get the sum for unique encounters since there are duplicates in my table.

       

      Thanks.