Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vbravomo
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
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
sureshqv
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
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)

Highlighted
francisco_valle
New Contributor II

Re: KPI by month

Hi Karen,

Try the following:

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

vbravomo
New Contributor

Re: KPI by month

Thank you!!!

vbravomo
New Contributor

Re: KPI by month

Thank you