Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

livio218526
Contributor

if all selection in filter pane

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

Tags (2)
1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: if all selection in filter pane

Maybe this scenario:

If I don't select contributeur or select them all;

I'd have this:

Capture.PNG

If I select contributeurs, I'll have this:

Capture.PNG

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é],' ')

)

6 Replies
Chanty4u
Esteemed Contributor III

Re: if all selection in filter pane

try

=Aggr( Concat( DISTINCT Month,'| '), IF(condition)

Chanty4u
Esteemed Contributor III

Re: if all selection in filter pane

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,'| ')

livio218526
Contributor

Re: if all selection in filter pane

No,  I want

Region | Month

But your function doesn't working. My function work but only if I don't selected all value.

livio218526
Contributor

Re: if all selection in filter pane

No, it is wrong

OmarBenSalem
Esteemed Contributor

Re: if all selection in filter pane

Maybe this scenario:

If I don't select contributeur or select them all;

I'd have this:

Capture.PNG

If I select contributeurs, I'll have this:

Capture.PNG

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é],' ')

)

livio218526
Contributor

Re: if all selection in filter pane

Thank you it's work correctly!!

Community Browser