stats for this month so far

[#1]

Hi all,

I am trying to put a KPI on my dashboard showing the number of invoices so far this month but unsure on how to achieve it.

can anyone help please?

i know i need to use a count(distinct Invoice_Number) but not sure how to add this month so far in.

Thanks

[Gysbert_Wassenaar · Accepted solution]

Assuming you have a field named Month:

count({<Month={'$(=month(today()))'}>} distinct Invoice_Number)

[#3]

If you have more than one year though, you will need to add

Year={'$(=year(today()))'}}

also

[#4]

ok thanks both. i am new to qlikview, how would i add the two of those in the same set analysis?

[Gysbert_Wassenaar]

Good point, Rebecca!

You can add the year clause like this:

count({<Year={'$(=year(today()))'}, Month={'$(=month(today()))'}>} distinct Invoice_Number)

[#6]

Thats great. thanks for your help both.