Qlikview - calculated format in table box

[sylvain_piccarreta]

Hi,

I have a table box like this :

ID                 Value

A                Removed

B                Keep

C                Removed

D                

E                To Remove

And I would like to put in green cells with the value Removed.

I try to use the calulated format with the formulas in the "Custom Format Cell" with the formulas if(value='Removed',RGC(128,255,128),(255,255,255)), but it's ok If I select only rows with Removed, but when I have the full table box, All cells are blanks even if cells with Removed.

Sylvain

[mfchmielowski · Accepted solution]

Hi.

TableBox is just for debug ourpouses. If you want to add formating formulas use chart > straight table.

[NitinK7]

try like below

exp- pick(WildMatch(Value,'*Removed*'),RGB(128,255,128),RGB(255,255,255))

[sylvain_piccarreta]

Thanks for your answer. I use the straight table instead of the table box