topic Re: Ignore selection in field, even when same dimension is selected in App Development

Ignore selection in field, even when same dimension is selected

ruben_moya — Sat, 16 Nov 2024 18:27:21 GMT

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!

Re: Ignore selection in field, even when same dimension is selected

agigliotti — Tue, 23 Jun 2020 07:55:09 GMT

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.

Re: Ignore selection in field, even when same dimension is selected

ruben_moya — Tue, 23 Jun 2020 08:33:34 GMT

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.

Re: Ignore selection in field, even when same dimension is selected

agigliotti — Tue, 23 Jun 2020 08:40:58 GMT

how does your variable vL.Total_amount looks like?

Re: Ignore selection in field, even when same dimension is selected

ruben_moya — Tue, 23 Jun 2020 08:46:57 GMT

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

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

Re: Ignore selection in field, even when same dimension is selected

agigliotti — Tue, 23 Jun 2020 09:09:16 GMT

what about:

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

Re: Ignore selection in field, even when same dimension is selected

ruben_moya — Tue, 23 Jun 2020 14:39:27 GMT

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.