Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It works for me, please review your expression.
try this
=if(match(GROUP_CLASS,'G3'),GROUPCLASS)
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.
Hi Miguel
I have try :-
=IF(GROUP_CLASS='G3',COMPANY)
it still not display any thing,
Paul Yeo
Hi Chanty
I try below , i get invalid expression :-
=IF(match(GROUP_CLASS,'G3',COMPANY)
Paul
try this
=if(match(GROUP_CLASS,'G3'),Company)
Hi Chanty
it does not work , i does not filter G3 , and display all company. no error
Paul
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?
Hi Miguel
Enclosed my QVW
It works for me, please review your expression.