Set analysis with Max Function

[Anonymous]

Hi All,

I have a requirement where in I have to show users with maximum submission count and the table to show only with flag  = yes

I had written the following expression : this is working fine for max submission based on users but the flag = yes isn't working(the table is showing flag = no as well):

max(aggr(sum({<Flag = {'Yes'}>}Submission),Users))

Any help will be much appreciated.

Kindly let me know if the requirement is unclear

Thanks,

Anupama Jagan

[jyothish8807]

Try this :

aggr(max({<Flag = {'Yes'}>} aggr(sum({<Flag = {'Yes'}>}Submission),Users,Region)),Users,Region)

else

max(aggr(max({<Flag = {'Yes'}>} aggr(sum({<Flag = {'Yes'}>}Submission),Users,Region)),Users,Region))

Br,

KC

[PrashantSangle]

nullify Region field in outer set analysis.

try below

max({<Flag = {'Yes'},Region=>} aggr(sum({<Flag = {'Yes'}>}Submission),Users))

Regards,