Color not applied when there are multiple records(rows)

[#1]

I'm trying to make an table (see beneath) in qliksense where:

- we can see which products are purchased by a specific customer, (this is working as intended)

- Which products are requested in an invoice,

Organisation      Product 1      Product 2      etc..

company 1         yes                no                ...

company 2         no                  no                ...

company 3         yes                yes              ...

etc.                     ...                  ...                  ...

Now, I want to color the background of the table when it says 'no' but the productcode (which is saved in another table) is used in an invoice for that customer.

The tables i am using:

[License]

AccountID

Product 1

Product 2

Product 3

...

[Invoice]

AccountID

Productcode

Whenever the invoice table gives back one row the color is applied as intented, however when there are multiple rows (different productcodes) in the table the color isn't applied at a single product of the license table. (see attached screenshot for an example of both situations)

The code i'm using to color the different fields inside the table:

If(iTask = 'Ja' , rgb(229,255,236),

If(Inf_artikelnummer = 'a229' , rgb(214,235,235)))

Can anyone help me with solving this behavior?

[sunny_talwar · Accepted solution]

May be try this:

If(iTask = 'Ja' , RGB(229,255,236),

If(WildMatch(Concat(DISTINCT Inf_artikelnummer, '|'), '*a229*'), RGB(214,235,235)))

[#3]

Thank you very much! This seems to do the trick, could you explain what you did? Because I don't understand exactly what you did or what the new formula is doing..