Conditional text color on dimension not working!

alurcade — Wed, 15 Mar 2017 20:31:12 GMT

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..

Re: Conditional text color on dimension not working!

ariel_klien — Tue, 28 Nov 2017 13:21:14 GMT

Hi,

Did you find a solution for that?

Ariel

topic Re: Conditional text color on dimension not working! in QlikView

Conditional text color on dimension not working!

Re: Conditional text color on dimension not working!