topic Re: Field with multiple values - Color items in QlikView

Field with multiple values - Color items

fgirardin — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I've got a table with data from my ERP that looks like this:

Item, Price, Status

Status can be: Active, Obsolete, ObsoleteBOM

An item can be active or obsolete. But it can also be Obs AND ObsBOM

I'm trying to color my items by checking the "Status" value. If there is only one status, it works fine (red items when status is Obsolete, ...) but as soon as an item has 2 values (Obs, ObsBOM), the color do not change

Here's the expression I'm using

=if(ITEM_STATUS ='BOMOBS' or ITEM_STATUS = 'OBS', rgb(255,0,0), black())

How can I still have my item turn red if both status are used

I'm pretty sure there is a simple solution but can't find it...

Thank you for your help

Re: Field with multiple values - Color items

Uday_Pasupuleti — Tue, 29 Oct 2019 09:08:02 GMT

Try If(Match(ITEM_STATUS ,'BOMOBS','OBS'),rgb(255,0,0), black())

Re: Field with multiple values - Color items

fgirardin — Tue, 29 Oct 2019 10:15:07 GMT

Sadly, it does not work. Items with both status still are in black

Re: Field with multiple values - Color items

Brett_Bleess — Wed, 06 Nov 2019 14:15:49 GMT

Fabien, just out of curiosity, what happens if you change the 'or' to an 'and'? My hunch would be this is something data model related if that works, so you may need to attach QVW or sample etc. such that folks can have a look at that too. Best idea I have to try to move things forward for you.

Regards,
Brett

Re: Field with multiple values - Color items

fgirardin — Thu, 07 Nov 2019 13:27:54 GMT

I?ve solved my issue using another solution, I replaced one value (ObsoleteBOM by Obsolete) at LOAD