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

amount of sales at the end of the month in expressions

Good day

Following problem, I can not count the amount of sales at the end of the month in expressions in pivot table

Sum(if(Date=Aggr(Max(Date),Month),Amount,0))

or

Sum(Aggr(FirstSortedValue(Amount,-Date),Month))

it does not work

FirmID
GoodsIDDateAmountMonth
1101.01.20135Jan
1231.01.20132Jan
1428.02.20133Feb
1228.02.20131Feb
1105.03.20134March
0 Replies