Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vbravomo
Contributor III
Contributor III

KPI by month

Hi everyone,

I need some help. I'm trying to create a KPI with the number of users in the current month. But it doesn't work with the following line:

Count({<Year(Num([Started On]))={$(year(today()))},Month(Num([Started On]))={$(upper(Month(today())))}>}USER)

I'm not sure if the problem could be USER is a dim; or if you can use this sentence only with SUM (But I need to count the users)

Thank you

Note: Started On is the date in this format: DD/MM/YY

1 Solution

Accepted Solutions
sunny_talwar

May be try this

Count({<[Started On] = {"$(='>=' & Date(MonthStart(Today()), 'DD/MM/YY') & '<' & Date(MonthStart(Today(), 1), 'DD/MM/YY'))"}>} USER)

View solution in original post

5 Replies
Chanty4u
MVP
MVP

try this

Note:  Started on   should be mapped with Master calendar 

count({<Year={$(=year(today()))},Month={'$(=upper(Month(today())))'}>}USER).

sunny_talwar

May be try this

Count({<[Started On] = {"$(='>=' & Date(MonthStart(Today()), 'DD/MM/YY') & '<' & Date(MonthStart(Today(), 1), 'DD/MM/YY'))"}>} USER)

francisco_valle
Partner - Contributor II
Partner - Contributor II

Hi Karen,

Try the following:

Count({<[Started On]={">=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))"}>}USER)

vbravomo
Contributor III
Contributor III
Author

Thank you!!!

vbravomo
Contributor III
Contributor III
Author

Thank you