topic Re: Background color in button - exclude in QlikView

Background color in button - exclude

Anonymous — Fri, 24 Jun 2016 08:45:37 GMT

Hi, QlikView Community

I have a simple dataset what you can look at in the excel file.

I have one trouble I am trying to solve regarding background color in button.

I have a button that has actions that is supposed to select two Company Codes (100 and 110).

And I use this formula below in the text button to change colors when Compmany Code 100 and 110.

=if(Concat(distinct [Company Code],',')='100,110',RGB(0, 240, 16), RGB(15, 48, 99))

It works exactly like I want to. But I how can use to the similar if formula to change colors in the button when I exclude

company code 100 and 110.

I know I could use this formula below for this dataset but I want to exclude 100 and 110

=if(Concat(distinct [Company Code],',')='120,130,140',RGB(0, 240, 16), RGB(15, 48, 99))

regards Darri

avinashelite — Fri, 24 Jun 2016 09:00:21 GMT

Try like this

=if(Concat(distinct [Company Code],',')='120,130,140' and Concat(distinct [Company Code],',')<>'100,110',

if(Concat(distinct [Company Code],',')<>'100,110',RGB(0, 240, 16), RGB(15, 48, 99)))

Fri, 24 Jun 2016 09:17:37 GMT

You can try this expression as well:

=IF(wildMatch(concat([Company Code],','),'*110*') AND wildMatch(concat([Company Code],','),'*100*'),RGB(0, 240, 16), RGB(15, 48, 99))

Anonymous — Fri, 24 Jun 2016 09:58:54 GMT

Hi, Sakir Ali

This formula worked when I selected company code 100 and 110.

But I wanted it to worked if excluded 100 and 110.

Anonymous — Fri, 24 Jun 2016 10:01:10 GMT

Hi, Avinah R

This formula worked exactly like I wanted.

But I am worried about when I have thousands company code and they are changing every month and it will a lot to work to update them.

Do you have any ideas?

regards Darri

avinashelite — Fri, 24 Jun 2016 10:48:43 GMT

push all those company code to variable and then compare the variable that will make the process automated