topic Re: Selection is failed in QlikView

Selection is failed

Mon, 17 Jun 2013 05:15:08 GMT

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

Re: Selection is failed

Mon, 17 Jun 2013 05:47:43 GMT

You can try like this.

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

Karthik

Re: Selection is failed

Mon, 17 Jun 2013 06:30:14 GMT

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

Re: Selection is failed

Mon, 17 Jun 2013 07:20:00 GMT

Thanks for your help

I tested the the formula but I have no success.

Can you please explain the formula nearer.

Re: Selection is failed

Mon, 17 Jun 2013 07:30:20 GMT

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.

Re: Selection is failed

Mon, 17 Jun 2013 07:54:54 GMT

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