Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Selection is failed

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

5 Replies
Not applicable

Re: Selection is failed

You can try like this.

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

Karthik

Not applicable

Re: Selection is failed

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

Re: Selection is failed

Thanks for your help

I tested the the formula but I have no success.

Can you please explain the formula nearer.

Not applicable

Re: Selection is failed

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

Re: Selection is failed

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

Community Browser