Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

date filtering issue

Hello

I have a table with many lines. each line contains an Id and a date of creation.

I am trying to display the  number of line for the current month but I get an expression error.

Could you help me ?

Thanks in advance


David

My expression is

count({$<month(date(date))=month(today())>[tickets.id])

1 Reply
omarbensalem
Esteemed Contributor

Re: date filtering issue

In your script, create a field month :

month(date) as month,

then in your expression:

count({<month={"$(=max(month))"}>}ticketID)