Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
raz-datamind
Partner - Contributor
Partner - Contributor

set analysis max week data

Hi,

I have an excel weekly plan data, i want to show this data on a monthly dimension, showing the data relevant for the max week for each month

i tried using:

sum(  Week={"=aggr(max(Week),Month)"} >} Data )

but i don't get the right results.

Anyone can help me please?

Thanks.

2 Replies
sushil353
Master II
Master II

Try this:

sum( {< Week={$(=aggr(max(Week),Month)} >} Data )

HTH

Sushil

manideep78
Partner - Specialist
Partner - Specialist

Try this

Sum({<Week={"$(=aggr(Max(Week),Month))"}>}Data)