Ignore selection in field, even when same dimension is selected

[ruben_moya]

Dear Experts, 

I'm having the following problem.

This expression allows me to get a list of all the companies in my data whose benefits (vL.Total_amount) are higher than a certain amount:

CONCAT(IF(AGGR($(vL.Total_amount),COMPANY_NAME)> 50000 ,COMPANY_NAME),'|')

I'd need that list to ignore any selection in the field COMPANY_NAME. Is that even possible? Does it make sense?

I need to get  a list of all the companies that meet that condition independently of the selections in the field COMPANY_NAME.

I've tried using the following expression. It works when I want to ignore other fields, but not with COMPANY_NAME:

concat(aggr(Only({<COMPANY_NAME=>}COMPANY_NAME),COMPANY_NAME),'|')

Thanks a lot for your time!

[agigliotti]

Hi,
Maybe this:

=CONCAT( {<COMPANY_NAME>}
IF(
AGGR( $(vL.Total_amount), COMPANY_NAME) > 50000 , COMPANY_NAME ), '|' )

also add {<COMPANY_NAME>} in your vL.Total_amount variable expression.

I hope it can helps.

[ruben_moya]

Hi Agigliotti ,

I've tried what you suggested and still not working. Once you select one value in the dimension COMPANY_NAME, the list gets automatically filtered.

[agigliotti]

how does your variable vL.Total_amount  looks like?

[ruben_moya]

It actually has another variables involved, but in the end it's something like:

Sum({< flag_X={'3'}>} total_amount)

[agigliotti · Accepted solution]

what about:

=CONCAT( {<COMPANY_NAME>}
IF(
AGGR( Sum( {< COMPANY_NAME, flag_X = {'3'} >} total_amount ), COMPANY_NAME) > 50000 , COMPANY_NAME ), '|' )

?

[ruben_moya]

Thanks a lot! that worked perfectly.

Can you explain me the solution? If I've understood correctly, my problem was that I was ignoring the field outside of the function concat. 

Thanks again.