topic Re: Button with opposite selection in App Development

Button with opposite selection

danimarc12 — Fri, 21 Jan 2022 08:58:25 GMT

Hello everyone!

I have an issue with a button in Qlik Sense. I need to show 2 different kinds of products (ID):

The first ones are shown clicking on a button wich set these conditions: 1) Select values in field A=4; 2) Select values in field B= 1,2,4.
The second ones have to be shown by another button which has to select values in field A <>4 OR values in field B <> 1,2,4.

For the first button it's easy but how can I set the second button?

Could anyone help me please?

Thank you!

Re: Button with opposite selection

vikasmahajan — Fri, 21 Jan 2022 09:45:24 GMT

Simply use excluded from button action

Vikas

Re: Button with opposite selection

danimarc12 — Fri, 21 Jan 2022 09:51:12 GMT

Hi @vikasmahajan ,

thanks for your answer. The solution isn't correct because of the logic meaning.

The contrary of "valueA AND valueB" is not "NOT valueA AND NOT valueB"

but

"NOT valueA OR NOT valueB". So, If you exclude, you're using the wrong logic condition.

Re: Button with opposite selection

chris_djih — Mon, 24 Jan 2022 12:23:30 GMT

There is another action that says "Select alternative values" or sometihn like that.
So your way to go is:
1. Select values in field A=4
2. Select values in field B= 1,2,4
3. Select alternative values

Re: Button with opposite selection

danimarc12 — Mon, 24 Jan 2022 13:17:10 GMT

Hi @chris_djih ,

thanks for ur answer too. Unfortunately it's the same because the alterative values for each field is gonna make the wrong logical selection.

Maybe I have to create a new dimension in the LOAD SCRIPT EDITOR?!

If anyone could help me I'll be very thankful!

Re: Button with opposite selection

chris_djih — Mon, 24 Jan 2022 13:40:02 GMT

Yes, this would be my next suggestion, combining the 2 dimensions into a new one.

Re: Button with opposite selection

danimarc12 — Mon, 24 Jan 2022 13:46:08 GMT

So @chris_djih how should I write correctly the new dimension?

LOAD

if(fieldA <> 4 OR fieldB <> {1,2,4}, productID) AS newfield

How can I exclude more than one value in the IF statement?

Re: Button with opposite selection

chris_djih — Mon, 24 Jan 2022 13:49:58 GMT

you can use Match or Wildmatch (if you need wildcards).

If( FieldA <> 4 OR not Match(FieldB,1,2,4)