9 Replies Latest reply: Oct 23, 2018 10:26 AM by Tim Poismans RSS

    Qlik Sense Pivot Table - Count Distinct question

    CATHY DUVALL

      I am working on the Pivot table in Qlik Sense which have both AppIDs and CustIDs but some of the entries do not have a CustID.  I wish to count AppIDs values only one time in each measure of the Pivot Table.  Most of the time this is working but on several entries where the CustID field in blank, that AppID value (even though it is not a duplicate) is not being counted.

       

      I thought using COUNT(DISTINCT AppID) should work but it is not counting the AppIDs that don't have a value in the CustID field.

       

      What am I doing wrong?  Please help.