Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
badicsis
Contributor
Contributor

Qlik sense set expression current year & month

Hi All, I have 2 columns in my table: AccountNumber and ServiceDateTime for the last 10 years.

I only want the table to display the Account Numbers that are in the current month & year.

All the topics I found here were either Sum or Count but I just simply want to display them.

I don’t want to edit the script as I need the rest of the data in other charts.

Thanks!

Labels (2)
1 Reply
Channa
Specialist III
Specialist III

=only({<ServiceDateTime = {">=$(YearStart(Today()))<$(=monthend(Today())"}>}AccountNumber )

 

try to change the date format remove the time

Channa