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

    Nested Set Modifiers

    Ashley Kuttler



      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.