Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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