Why this expression not work =IF(GROUP_CLASS="G3",COMPANY)

[paulyeo11]

Hi All

I want to filter only display those customer handle by G3.

So instead of COMPANY field at dimension.

I replace with :-

=IF(GROUP_CLASS="G3",COMPANY)

But it got error , does not filter , and not display any company.

Paul

[Chanty4u]

try this

=if(match(GROUP_CLASS,'G3'),GROUPCLASS)

[Miguel_Angel_Baeyens]

If both fields exist in the data model and G3 is a value in the field GROUP_CLASS, then use single quotes instead of doubles in the If() comparison.

[paulyeo11]

Hi Miguel

I have try :-

=IF(GROUP_CLASS='G3',COMPANY)

it still not display any thing,

Paul Yeo

[paulyeo11]

Hi Chanty

I try below , i get invalid expression :-

=IF(match(GROUP_CLASS,'G3',COMPANY)

Paul

[Chanty4u]

try this

=if(match(GROUP_CLASS,'G3'),Company)

[paulyeo11]

Hi Chanty

it does not work , i does not filter G3 , and display all company. no error

Paul

[Miguel_Angel_Baeyens]

Can you share at least a screenshot where we can see two listboxes, one for GROUP_CLASS with G3 selected and another for COMPANY?

Are you sure there are values?

[paulyeo11]

Hi Miguel

Enclosed my QVW

[Miguel_Angel_Baeyens · Accepted solution]

It works for me, please review your expression.