Rangesum below is not working for second materal

[Anonymous]

Hi ,

I am applying an expression of rangesum below function to try to get the total detail value after a specific Cal Week as the value of Cal week, I use this expression

Concat(DISTINCT aggr( rangesum(below(sum(Detail), 1, 334)),[Cast Week],Material,Loc,[Cal Week]), '') ,

but it only works for first material, it doesn't work from second material, I have uploaded the qvw file. Can someone help me about this ?

[qliksus]

I am assuming you want to display the data from 201804  and show the last week accumulated value for that month . if so the below expression should be fine

(sum(total<[Cast Week],[Rep Item],[Matl Code],[Location Code]>  Detail) -

sum(total<[Cast Week],[Rep Item],[Matl Code],[Location Code],[Cal Period]>Detail) ) * (

PurgeChar( [Cal Period] > only({<[Cal Period]={"=wildmatch(trim(Replace([Cast Week],'WF','')) , '*'&[Cal Period]&'*')=1"}>} total [Cal Period]),'-') )