Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sylvain_piccarreta
Contributor III
Contributor III

Qlikview - calculated format in table box

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

1 Solution

Accepted Solutions
mfchmielowski
Contributor III
Contributor III

Hi.

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

View solution in original post

3 Replies
mfchmielowski
Contributor III
Contributor III

Hi.

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

View solution in original post

NitinK7
Creator III
Creator III

try like below

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

NitinK7_1-1614083467739.png

 

sylvain_piccarreta
Contributor III
Contributor III

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