Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Color not applied when there are multiple records(rows)

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)

example.jpg

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?

1 Solution

Accepted Solutions

Re: Color not applied when there are multiple records(rows)

May be try this:

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

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

2 Replies

Re: Color not applied when there are multiple records(rows)

May be try this:

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

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

Not applicable

Re: Color not applied when there are multiple records(rows)

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

Community Browser