Set Analysis MaxString on one dimension

[abonnery]

Dear Qlik Experts, 

I am trying to do a simple set analysis where the only criteria includes a MaxString. Here is the line of code I have tried for now: 

sum({$<[Cost Baseline Version - FA]={"(=MaxString(All [Cost Baseline Version - FA]))"}>} [EAC - FA]/1000000)

The results with this line of code is 0 for everywhere.

The line MaxString(All [Cost Baseline Version - FA]) works and directs me where the correct answer, I just don't know how to do a set analytic that sum all 'EAC -FA' whith this maxtring as a filter. 

Thank you very much for your help. 

[AshutoshBhumkar · Accepted solution]

Hello,

Try below

sum({$<[Cost Baseline Version - FA]={"$(=MaxString(All [Cost Baseline Version - FA]))"}>} [EAC - FA]/1000000)

or

sum({$<[Cost Baseline Version - FA]={$(=MaxString(All [Cost Baseline Version - FA]))}>} [EAC - FA]/1000000)

Reference

https://community.qlik.com/t5/New-to-Qlik-Sense/set-analysis-with-MaxString/td-p/738794

Thanks,
Ashutosh