Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
what about:
=CONCAT( {<COMPANY_NAME>}
IF(
AGGR( Sum( {< COMPANY_NAME, flag_X = {'3'} >} total_amount ), COMPANY_NAME) > 50000 , COMPANY_NAME ), '|' )
?
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.
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.
how does your variable vL.Total_amount looks like?
It actually has another variables involved, but in the end it's something like:
Sum({< flag_X={'3'}>} total_amount)
what about:
=CONCAT( {<COMPANY_NAME>}
IF(
AGGR( Sum( {< COMPANY_NAME, flag_X = {'3'} >} total_amount ), COMPANY_NAME) > 50000 , COMPANY_NAME ), '|' )
?
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.