Sheet Action - Not equal to

[kriyer]

Hi,

I am relatively new to Qlik Sense and have a question. Hope some expert will be able to help me

I need to set a Field Account Name to  "not equal to Peer Group"  when the user lands at the sheet and pull only data for Account Name not equal to Peer Group.  i tried putting in Action -> Select values matching specific criteria.   Field Account Name. In the expression I tried  <> 'Peer Group'.  I also tried entering [Account Name] -= {'Peer Group'} however none of them works.

Please help!

Thanks

[justISO]

Hi, maybe short workaround would be to use 2 actions: first, 'Select values in a field' 'Field Account Name' 'Peer Group'. And second, 'Select alternatives' in same 'Field Account Name' field. So you select this 'Peer group', but later you take everything, except that, like not equal to.

[BrunPierre]

Hi maybe so

String Search:   (not Like "Peer Group")

[kriyer]

Thank you @justISO .   I had tried this earlier however it didn't work right all the time.  maybe a bug in Qlik Sense.

Any other way?

Thanks

[kriyer]

Thanks @BrunPierre 

Can you please provide the exact syntax for NOT?  I am using Select Values Matching Specific Criteria.  Is that the right way?

[BrunPierre]

Select values in a field: [Account Name]

Value: (not Like "Peer Group")

or

set the Value equal to the expression below

Concat({<[Account Name]={"*"}-{"Peer Group"}>} DISTINCT [Account Name], ';')