topic Re: Problem with formula for setting color in Textbox in QlikView

Problem with formula for setting color in Textbox

Mon, 26 Jan 2026 16:26:21 GMT

Hello everybody,

I have a problem with a formula. The formula looks like:

IF(index(concat(Datum_verg&Severity,','),'4NM')>0,Yellow(),

IF(index(concat(Datum_verg&Severity,','),'4I')>0,LightBlue(),

IF(index(concat(Datum_verg&Severity,','),'4A')>0,LightRed(),

IF(DAY(MakeDate(Year(Today()),Month(Today()),4))<DAY(Today()),LightGreen(),White()))))

For examplI if I have data in my table for the 24.01.2014 so Datum_verg will create with 24. The textbox of the 24 will mark with the color for Severity. But the Textbox for the 4 will also mark like the 24.

See for more information the attachment.

What can I do can anyone help me.

Thanks

grettings sven

Re: Problem with formula for setting color in Textbox

giakoum — Tue, 28 Jan 2014 13:07:33 GMT

Try using subfield instead of index

Re: Problem with formula for setting color in Textbox

Tue, 28 Jan 2014 13:20:04 GMT

Can you please explaine or insert an example thanks

Re: Problem with formula for setting color in Textbox

giakoum — Tue, 28 Jan 2014 13:30:45 GMT

so it does, because the search string is present in both string (4NM and 24NM both contain 4NM). Is there no other field to use to determine?

Re: Problem with formula for setting color in Textbox

jerem1234 — Tue, 28 Jan 2014 13:55:42 GMT

So your problem is with the formula marking both 4NM and 24NM with the same value? Why don't you create dummy characters in the beginning, middle and end like:

=IF(index(concat('|' &Datum_verg& '|' & Severity & '|',','),'|4|NM|')>0,Yellow(),

IF(index(concat('|' &Datum_verg& '|' & Severity & '|',','),'|4|I|')>0,LightBlue(),

IF(index(concat('|' &Datum_verg& '|' & Severity & '|',','),'|4|A|')>0,LightRed(),

IF(DAY(MakeDate(Year(Today()),Month(Today()),24))<DAY(Today()),LightGreen(),White()))))

or maybe even better, use match function such as:

=IF(max(match(Datum_verg&Severity,'24NM')),Yellow(),

IF(max(match(Datum_verg&Severity,'24I')),LightBlue(),

IF(max(match(Datum_verg&Severity,'24A')),LightRed(),

IF(DAY(MakeDate(Year(Today()),Month(Today()),24))<DAY(Today()),LightGreen(),White()))))

If this doesn't help, can you explain a little more of what you are trying to achieve?

Hope this helps!

Re: Problem with formula for setting color in Textbox

Tue, 28 Jan 2014 14:33:49 GMT

Hi jerem,

I use the second function and it works. Thanks for your help.

I use this for a safteycross for our plant, so we have a table for all accidents in it. The colors ar standing for different severitys. So we can represent the achtually month on our teamboards

Greetings Sven