topic Re: stats for this month so far in QlikView

stats for this month so far

Wed, 14 Nov 2012 16:02:30 GMT

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 — Wed, 14 Nov 2012 17:08:09 GMT

Assuming you have a field named Month:

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

Wed, 14 Nov 2012 17:09:28 GMT

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

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

also

Wed, 14 Nov 2012 17:16:28 GMT

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

Gysbert_Wassenaar — Wed, 14 Nov 2012 17:21:04 GMT

Good point, Rebecca!

You can add the year clause like this:

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

Wed, 14 Nov 2012 17:34:48 GMT

Thats great. thanks for your help both.