Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a problem. I want to create a measure that show me a text 'WW' when i selected all value from a filter pane and concatenate ' | ' and another dimension like this:
TEST | TEST1
my function is:
=if([MGMT_REPORT.Region]='APAC' AND [MGMT_REPORT.Region]='EMEA' AND [MGMT_REPORT.Region]='NAFTA' AND [MGMT_REPORT.Region]='LATAM','WW',[MGMT_REPORT.Region]) & ' | ' & [MGMT_REPORT.Month]
but it doesn't working.
If i selected ALL value for Region and Dec for Month, so i want --> WW | Dec, instead of if i selected APAC as region, i want APAC | Dec
Please help me,
Thanks,
Livio
Maybe this scenario:
If I don't select contributeur or select them all;
I'd have this:
If I select contributeurs, I'll have this:
the expression of the text box to do this is: (try to adapt it to ur data)
if(count(distinct Contributeur)=count(all distinct Contributeur) or len(GetFieldSelections(Contributeur))=0,
'All '&' | '& concat(distinct [Activité],' '),
Concat(distinct Contributeur,' ')&' | '&concat(distinct [Activité],' ')
)
try
=Aggr( Concat( DISTINCT Month,'| '), IF(condition)
try
=if([MGMT_REPORT.Region]='APAC' AND [MGMT_REPORT.Region]='EMEA' AND [MGMT_REPORT.Region]='NAFTA' AND [MGMT_REPORT.Region]='LATAM','WW',[MGMT_REPORT.Region]),Aggr( Concat( DISTINCT Month,'| ')
No, I want
Region | Month
But your function doesn't working. My function work but only if I don't selected all value.
No, it is wrong
Maybe this scenario:
If I don't select contributeur or select them all;
I'd have this:
If I select contributeurs, I'll have this:
the expression of the text box to do this is: (try to adapt it to ur data)
if(count(distinct Contributeur)=count(all distinct Contributeur) or len(GetFieldSelections(Contributeur))=0,
'All '&' | '& concat(distinct [Activité],' '),
Concat(distinct Contributeur,' ')&' | '&concat(distinct [Activité],' ')
)
Thank you it's work correctly!!