Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi maybe so
String Search: (not Like "Peer Group")
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
Thanks @BrunPierre
Can you please provide the exact syntax for NOT? I am using Select Values Matching Specific Criteria. Is that the right way?
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], ';')