Selection is failed

[#1]

Hello everybody.

I have a problem with a table and textboxes.

I have a selection of data to be displayed in the textbox as colored. If I have only one entry in my data table the required text box is highlighted.

Once more data are available in the table, the mark is no longer running.

What can I do?

For example a qvw is added.

greetings Sven

[#2]

You can try like this.

SubStringCount('|' &Concat(Datum_verg, '|')& '|','|1|')

Karthik

[#3]

You can achive the result using concat and index function.

Example for Datum_verg=5, Schicht='A' and HALLE=1

=IF( index(concat(Datum_verg,','),'5')>0 and index(concat(Schicht,','),'A')>0 and index(concat(HALLE,','),'1')>0,Red(),

IF(DAY(MakeDate(Year(Today()),Month(Today()),5))<DAY(Today()),Green(),White()))

Attached the updated QVW file for your reference

Thanks,

K.Raja

[#4]

Thanks for your help

I tested the the formula but I have no success.

Can you please explain the formula nearer.

[#5]

I tested the formula in other textboxes.

And for the example aboth if I change the Schicht A to B, the textbox will also colored to red. Although in the data table no Schicht= B for Datum-Vergl=5.

[#6 · Accepted solution]

try with combination of Datum_verg&Schicht&HALLE.

=IF(index(concat(Datum_verg&Schicht&HALLE,','),'1A1')>0,Red(),

IF(DAY(MakeDate(Year(Today()),Month(Today()),1))<DAY(Today()),Green(),White()))