topic Re: Panel with conditional in QlikView

Panel with conditional

Anonymous — Mon, 25 Jul 2016 20:05:59 GMT

Good afternoon,

EQUIPMENT have a table with fields:

n_Plaqueta	C_Descricao
1010	Computer
1011	Notebook

Another CALLED with the fields:

n_plaqueta	I_idChamado	D_chamados
1010	001	Maintenance
1011	002	Maintenance
1012	003	Maintenance

I need to change the color of the field or the cell-called platelets is not registered in the table equipment.

Re: Panel with conditional

sunny_talwar — Mon, 25 Jul 2016 20:43:55 GMT

May be like this as your text color expression:

If(Len(Trim(Concat(DISTINCT C_Descricao, ','))) = 0, LightRed())

Re: Panel with conditional

Anonymous — Mon, 25 Jul 2016 21:09:04 GMT

Check that the number of platelets that was entered in the table has called on the equipment table, if not it changes the color of n_plaqueta field in my table called does not have the description of the equipment.

Re: Panel with conditional

maheshkuttappa — Mon, 25 Jul 2016 21:38:21 GMT

Do the below changes in script (you can use Applymap which will be more efficient)

LOAD * INLINE [

n_Plaqueta,C_Descricao

1010,Computer

1011,Notebook];

LOAD

if(Lookup('n_Plaqueta','n_Plaqueta',n_Plaqueta,'A')=n_Plaqueta,1,0) as _Flag;

Load * INLINE [n_Plaqueta,I_idChamado,D_chamados

1010,001,Maintenance

1011,002,Maintenance

1012,003,Maintenance];

text color Definition:

If(_Flag = 0, LightRed())

Panel with conditional