Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum only records of today's month

Hi !

i am trying to create an expression that will sum a field but only when the record's date is today's month.

this is what i wrote and it's incorrect:

=sum({<MonthName(date) = {"monthName(Today())"} >} clicks)

for example:

dateclicks
10/1/201310
10/2/20133
10/3/20137
10/4/20138
10/5/20133
9/1/20132
9/2/20138
9/3/20133
9/4/20139
9/5/2013

2

i want the expression to sum only the records from October.

10 Replies
Not applicable
Author

Then if it works, what does not work is to use a field in the database function sets:

= sum ({<CtaMov = {$(=maxstring(Filtro))}>} Value)

where filter is a field in a table that one of your values ​​is by example

640*, 641*    or     640,641

and the result will be 10.