Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be try this:
If(iTask = 'Ja' , RGB(229,255,236),
If(WildMatch(Concat(DISTINCT Inf_artikelnummer, '|'), '*a229*'), RGB(214,235,235)))
May be try this:
If(iTask = 'Ja' , RGB(229,255,236),
If(WildMatch(Concat(DISTINCT Inf_artikelnummer, '|'), '*a229*'), RGB(214,235,235)))
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..