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

    Count total number, ignoring chart filters



          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!