How to find maximum value of an aggregated expression?

[#1]

Hi All

I have the following graph with

Dimensions: Country, GLOBAL_ITEM_ID and Yr_Wk_Frcst and I need to output the maximum value of the 2 expressions in a texbox:

I need edit below expression to retrieve maximum value 8605 of Expression number 1:

sum({<Period_Week_Counter={">=$(=max(Period_Week_Counter)-2) <$(=max(Period_Week_Counter))"}, OPE_WEK=, OPE_YY=>}Aggr(sum({<Period_Week_Counter={">=$(=max(Period_Week_Counter)-2) <$(=max(Period_Week_Counter))"}, OPE_WEK=, OPE_YY=>}STK_QT),GLOBAL_ITEM_ID,Yr_Wk_Frcst))

I need edit below expression to retrieve maximum value 19.3 of Expression number 2:

(sum({<Period_Week_Counter={">=$(=max(Period_Week_Counter)-2) <$(=max(Period_Week_Counter)+10)"}, OPE_WEK=, OPE_YY=>}Aggr(sum({<Period_Week_Counter={">=$(=max(Period_Week_Counter)-2) <$(=max(Period_Week_Counter)+10)"}, OPE_WEK=, OPE_YY=>}STK_QT),GLOBAL_ITEM_ID,Yr_Wk_Frcst))/sum({<Period_Week_Counter={">=$(=max(Period_Week_Counter)-2) <$(=max(Period_Week_Counter)+10)"}, OPE_WEK=, OPE_YY=>}Aggr(sum({<Period_Week_Counter={">=$(=max(Period_Week_Counter)-2) <$(=max(Period_Week_Counter)+10)"}, OPE_WEK=, OPE_YY=>}SHIPMENT_AVG_3_WEEKS),GLOBAL_ITEM_ID,Yr_Wk_Frcst)))*5

Can you please help?

[#2]

Yes both your last expressions return the value 30.7.

Your last expression is almost similar to the expression which produces value 27.6

I did several trials by editing it a bit and removing the "+ 10" from the period_counter in the condition and added aggregation by GLOBAL_ITEM_ID,Yr_Wk_Frcst, Country. THen it produced the correct value of 27.6

Next im trying to obtain the same max values for the future period from max(Period_Week_Counter) till the max number of weeks available and this period is associated with a different set of KPIs in the same graph that is why they are of different color.

I will create a different discussion thread for this hehe

Again many thanks to you guys and have a great day!

[swuehl]

Have a nice day, too.

If you create a new thread, please try to add a small sample application.

It's much easier to help  having the full range of information (am I repeating myself ).

[sunny_talwar]

Just to reiterate Stefan's words, sample is the best way to get fastest solutions to your problems. Look at some of these threads:

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample