# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

## 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

Tags (2)
1 Solution

Accepted Solutions
MVP

## Re: KPI by month

May be try this

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

5 Replies
Esteemed Contributor III

## Re: KPI by month

try this

Note:  Started on   should be mapped with Master calendar

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

MVP

## Re: KPI by month

May be try this

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

New Contributor II

## Re: KPI by month

Hi Karen,

Try the following:

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

New Contributor

Thank you!!!

Highlighted
New Contributor

Thank you