topic Re: Qlik Sense Server - Custom expression to add filter pane value in Management & Governance

Qlik Sense Server - Custom expression to add filter pane value

marceloromero — Fri, 15 Nov 2024 20:58:29 GMT

Hello devs,

I have a list of entries with a column named Transaction_ID that describes what type of transaction is it. It can contain codes from a big list (an integer between 0 and 100) but only a group of them are what we call 'Client Transactions'.

I'm now creating a dashboard and a collegue asked me to add a filter pane with an option to toggle between 'Client Transactions' and the rest of them, so I created something like this:

In 'Champ' I put the following condition: =Transaction_ID=10 Or Transaction_ID=11 Or ... etc (with the list of transactions that are considered 'Client Transactions')

This creates a filter with two options, -1 (when the condition is true) and 0 (when the condition is false).

How could I replace -1 and 0 for custom values (like True and False)?

Thanks,

Marcelo

Re: Qlik Sense Server - Custom expression to add filter pane value

mpc — Tue, 14 May 2024 09:03:10 GMT

Hi,

Since Boolean in Qlik are of type Dual, maybe this should work:

=Text(Transaction_ID=10 Or Transaction_ID=11)

Kind regards

Re: Qlik Sense Server - Custom expression to add filter pane value

marceloromero — Tue, 14 May 2024 11:17:16 GMT

Text still showed '-1' and '0' but I found another post where they explained the solution:

https://community.qlik.com/t5/QlikView-App-Dev/Showing-boolean-data-as-a-check-box-or-similar/td-p/308968

It was solved writing:

If(Transaction_ID=10 Or Transaction_ID=11, 'True', 'False')