topic Re: Qlikview - calculated format in table box in QlikView

Qlikview - calculated format in table box

sylvain_piccarreta — Tue, 23 Feb 2021 10:35:46 GMT

Hi,

I have a table box like this :

ID Value

A Removed

B Keep

C Removed

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

Re: Qlikview - calculated format in table box

mfchmielowski — Tue, 23 Feb 2021 11:11:03 GMT

Hi.

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

Re: Qlikview - calculated format in table box

NitinK7 — Tue, 23 Feb 2021 12:31:28 GMT

try like below

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

Re: Qlikview - calculated format in table box

sylvain_piccarreta — Thu, 04 Mar 2021 09:46:46 GMT

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