Qlik Sense Server - Custom expression to add filter pane value

[marceloromero]

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

[mpc]

Hi, 

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

=Text(Transaction_ID=10 Or Transaction_ID=11)

Kind regards

[marceloromero · Accepted solution]

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/3...

It was solved writing:

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