topic set analysis max week data in QlikView

set analysis max week data

raz-datamind — Mon, 11 Mar 2013 12:14:35 GMT

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.

sushil353 — Mon, 11 Mar 2013 12:20:06 GMT

Try this:

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

HTH

Sushil

manideep78 — Mon, 11 Mar 2013 12:20:22 GMT

Try this

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