Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selection is failed

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

1 Solution

Accepted Solutions
Not applicable
Author

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()))

View solution in original post

5 Replies
Not applicable
Author

You can try like this.

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

Karthik

Not applicable
Author

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

Not applicable
Author

Thanks for your help

I tested the the formula but I have no success.

Can you please explain the formula nearer.

Not applicable
Author

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.

Not applicable
Author

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()))