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

In your script, create a field month :

month(date) as month,

then in your expression:

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