topic Re: Sheet Action - Not equal to in App Development

Sheet Action - Not equal to

kriyer — Mon, 26 Dec 2022 18:47:20 GMT

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

Re: Sheet Action - Not equal to

justISO — Tue, 27 Dec 2022 06:50:35 GMT

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.

Re: Sheet Action - Not equal to

BrunPierre — Tue, 27 Dec 2022 08:27:16 GMT

Hi maybe so

String Search: (not Like "Peer Group")

Re: Sheet Action - Not equal to

kriyer — Tue, 27 Dec 2022 13:38:01 GMT

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

Re: Sheet Action - Not equal to

kriyer — Tue, 27 Dec 2022 13:41:50 GMT

Thanks @BrunPierre

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

Re: Sheet Action - Not equal to

BrunPierre — Tue, 27 Dec 2022 15:10:30 GMT

Select values in a field: [Account Name]

Value: (not Like "Peer Group")

set the Value equal to the expression below

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