Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Conditional text color on dimension not working!

Hi All,

This may seem a very naive question but I havent found the answer for it quite yet. I have a simple pivot chart with 5 dimensions and three expressions. This charts shows 2 product codes and 2 product description as the vertical dimensions, production date as my horizontal dimension and finally production quantity (in KG, boxes and pieces) as expressions. I have formulated the following calculated expression (on the text color option) for the first 4 dimensions:

=if(Calidad_SA='HALAK',rgb(255,110,110),IF(Calidad_SA='HAR',RGB(155, 89, 182),IF(Calidad_SA='REGULAR',BLACK(),IF(MATCH(Calidad_SA,'NESHER','KOSHER'),GREEN())))).

This condition works perfectly when there is data on the expression, but it does not work when data is not present.

For example. This chart shows all colored dimensions that are categorized as either "KOSHER/NESHER". The condition is met for most codes except for 4 of them (1273,1276,1285,1282) because there is no production data for these codes for production date 09/03/2017, thus, it does not color it in green.

How can I go around this issue?

Much thanks for your help..


1 Reply


Did you find a solution for that?