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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

MTD calculate

What error in the expression it is MTD calculation.

=Sum( {<[Util Daterep] = { ' >=$(=Max((MonthStart([Util Daterep])))) <=$(Max([Util Daterep]) '  }>} [Amount Verified])

Jay

2 Replies
its_anandrjs
Champion III
Champion III

You have to write

=Sum({<[Util Daterep]= {'>=$(=Max((MonthStart([Util Daterep])))) <=$(=Max([Util Daterep]))'}>} [Amount Verified])

Some Bracket and comma mistake

Regards

Anand

Not applicable
Author

Small mistakes any other way of same problem.

Jay