topic Re: Text object change color when value get associated in QlikView

Text object change color when value get associated

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hello everyone

In below, i used Action>select in field on text object. my query is when i select abc from emp_name list box that time text object will show as a active as below.

Thank You.

Re: Text object change color when value get associated

rubenmarin — Mon, 08 Jan 2018 11:15:37 GMT

Hi Prachi, for only that value selected can be set the conditional color to:

If(emp_name='abc', RGB(Color1), RGB(Color2)) // Change ColorX to the color codes

For that value in selected values can be:

If(Index(';' & GetFieldSelections(emp_name, ';') & ';', 'abc'), RGB(Color1), RGB(Color2)) // Change ColorX to the color codes

Re: Text object change color when value get associated

devarasu07 — Mon, 08 Jan 2018 11:17:10 GMT

Hi,

try like below,

just create calculated text box color using below expression

if(GetFieldSelections(emp_name)='abc',green(),White())

note: if you selecting multi value then u have use concatenate function within the expression

Re: Text object change color when value get associated

Anonymous — Mon, 08 Jan 2018 11:21:07 GMT

i don't want to show for a single value, i want to show like if i select any value associated with IT or BPO then it will change color

Re: Text object change color when value get associated

neha_shirsath — Mon, 08 Jan 2018 11:23:12 GMT

Please find the attached file.

Re: Text object change color when value get associated

Anonymous — Mon, 08 Jan 2018 11:26:02 GMT

I have PE ,please share screen shot

Re: Text object change color when value get associated

devarasu07 — Mon, 08 Jan 2018 11:27:59 GMT

then u can use getselectedcount function.

if(GetSelectedCount(emp_name)>0,green(),White())

Re: Text object change color when value get associated

rubenmarin — Mon, 08 Jan 2018 11:30:15 GMT

Very similar to use with Dept field, only change is that values are not selected directly, so GetFieldSelctions can't be used:

If(Index(';' & Concat(Distinct Dept, ';') & ';', ';IT;'), RGB(Color1), RGB(Color2)) // Change ColorX to the color codes

The semicolons is to avoid miscounts with possible departments containing string 'IT' in the full name

Re: Text object change color when value get associated

mdmukramali — Mon, 08 Jan 2018 11:35:56 GMT

Hi,

can you try the below color expression :

for BPO :

=if(Concat(Distinct Dept,',')<>Concat(DISTINCT{1} Dept,',') and Index(Concat(Distinct Dept,','),'BPO')=1,Green(),RGB(213,238,248))

for IT:

=if(Concat(Distinct Dept,',')<>Concat(DISTINCT{1} Dept,',') and Index(Concat(Distinct Dept,','),'IT')=1,Green(),RGB(213,238,248))

Re: Text object change color when value get associated

sasikanth — Mon, 08 Jan 2018 11:36:44 GMT

Hi Prachi,

you can use below expression

For IT text Object:

=IF( SubStringCount(Concat( Dept,'|'),'IT')>0 ,Green())

For BPO text object :

=IF( SubStringCount(Concat( Dept,'|'),'BPO') >0 ,Green())

Re: Text object change color when value get associated

neha_shirsath — Mon, 08 Jan 2018 11:36:52 GMT

Re: Text object change color when value get associated

mdmukramali — Mon, 08 Jan 2018 11:40:04 GMT

Hi,

even you can try this one also:

for BPO:

=if(Concat(Dept,',')<>Concat({1}Dept,',') and Index(Concat(Distinct Dept,','),'BPO')>=1,Green(),RGB(213,238,248))

for IT:

=if(Concat(Dept,',')<>Concat({1}Dept,',') and Index(Concat(Distinct Dept,','),'IT')>=1,Green(),RGB(213,238,248))

Re: Text object change color when value get associated

Anonymous — Mon, 08 Jan 2018 12:21:27 GMT

It works fine but when i select aabb from BPO & abc from IT then it shows like inactive .

my requirement is when i select both value then it change with green color.

Re: Text object change color when value get associated

mdmukramali — Mon, 08 Jan 2018 12:30:44 GMT

Hi,

Final Try:

for BPO:

=if((Concat(Dept,',')<>Concat({1}Dept,',') and Index(Concat(Distinct Dept,','),'BPO')>=1)

(GetSelectedCount(Dept)>=1 and Index(Concat(Distinct Dept,','),'BPO')>=1)

,Green(),RGB(213,238,248))

For IT :

=if((Concat(Dept,',')<>Concat({1}Dept,',') and Index(Concat(Distinct Dept,','),'IT')>=1)

(GetSelectedCount(Dept)>=1 and Index(Concat(Distinct Dept,','),'IT')>=1)

,Green(),RGB(213,238,248))

Re: Text object change color when value get associated

neha_shirsath — Mon, 08 Jan 2018 12:39:17 GMT

Add the below condition in your text box expression-

=if(GetSelectedCount(EmpName)>1,Concat(Dept,chr(10)),Dept)

Re: Text object change color when value get associated

Anonymous — Mon, 08 Jan 2018 12:51:46 GMT

hello neha

when i select BPO text object it shows IT details and same with IT text object but when i select values from list box then it works fine.

Re: Text object change color when value get associated

sasikanth — Mon, 08 Jan 2018 13:22:21 GMT

Try with below expressions

For BPO:

=IF( SubStringCount(Concat( Dept,'|'),'BPO') >0 and GetSelectedCount(EmpName)>0 ,Green())

FOR IT:

=IF( SubStringCount(Concat( Dept,'|'),'IT') >0 and GetSelectedCount(EmpName)>0 ,Green())

Re: Text object change color when value get associated

neha_shirsath — Tue, 09 Jan 2018 03:36:08 GMT

Hi, what is issue now?