Count total number, ignoring chart filters

[#1]

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

[alexandros17]

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

let me know (Write the correct name for month and year)

[#3]

Hi, thanks for fast answering.

  Not working as it counts the total per line, not the total per customer. I presume should be something like this...

Sum(Count({$<TRXTYPETXT={1,3}, Mois=, FISCYR=>} [IDINVC],NAMECUST))

what do you think?

Thanks again!

[alexandros17]

Could you send me the document?

[#5]

It's the one called ''Rapport de ventes général''.

Thanks!

[alexandros17]

Sorry I cannot open it

[#7]

If I give you this, is it understandable?

[#8 · Accepted solution]

Aggr(count(DISTINCT {$<Year2=,Month2=>} IDINVC),NAMECUST)

Thanks for your help!

Pat