Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Assuming you have a field named Month:
count({<Month={'$(=month(today()))'}>} distinct Invoice_Number)
Assuming you have a field named Month:
count({<Month={'$(=month(today()))'}>} distinct Invoice_Number)
If you have more than one year though, you will need to add
Year={'$(=year(today()))'}}
also
ok thanks both. i am new to qlikview, how would i add the two of those in the same set analysis?
Good point, Rebecca!
You can add the year clause like this:
count({<Year={'$(=year(today()))'}, Month={'$(=month(today()))'}>} distinct Invoice_Number)
Thats great. thanks for your help both.