7 Replies Latest reply: Feb 5, 2015 3:42 PM by Patrick Girardin RSS

    Count total number, ignoring chart filters

      Hi,

       

          Newbie on Qlik Sense products, sorry for basic question.

       

          I need to count the total number of invoices per customer in a table, but wish to ignore all the filters .(because we filter by months/year, but still wish to view the total invoice from the beginning)

       

           Here is what I have for now:

       

          Count(distinct {$<TRXTYPETXT={1,3}>} [IDINVC])

       

      Many thanks!

       

      Patrick