Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Panel with conditional

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.

1 Solution

Accepted Solutions
maheshkuttappa
Creator II
Creator II

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

A:

LOAD * INLINE [

n_Plaqueta,C_Descricao

1010,Computer

1011,Notebook];

B:

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

View solution in original post

3 Replies
sunny_talwar

May be like this as your text color expression:

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

Anonymous
Not applicable
Author

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.

Equipamento.jpg

maheshkuttappa
Creator II
Creator II

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

A:

LOAD * INLINE [

n_Plaqueta,C_Descricao

1010,Computer

1011,Notebook];

B:

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