QlikView App Dev

[qlikapple]

Hi ,

I have fileds lik this ,

My requirement is

Can anyoneplease help as it is very urgent for me

[Anil_Babu_Samineni]

May be this?

If( [No of team managers] <2, Amber())

If([No of Member] =2, Amber(), If([No of Member] <2, Red())

Note - Amber() is not a direct color function. You can manipulate wit your RGB code

[qlikapple]

is there any possbility , can i keep in the table it self

[Anil_Babu_Samineni]

Yes, You can use Text Color / BG color while expansion of expression ..

[qlikapple]

My requirement  is

if no of  team memers is 2,it should show yellow,

if no of  team memers is  greater than 2,normal black

if no of  team memers is  less  than 2,red

i need the text color

can anyone please help

[Anil_Babu_Samineni]

Yes, You can do something like below

If([no of  team memers]=2, Yellow(), If([no of  team memers] > 2, Black(), If([no of  team memers] <2, Red())))

[qlikapple]

hi

no luck

[Anil_Babu_Samineni]

What formula is applied for [No of Members] ??

[CELAMBARASAN]

Hi Sahaja

You formula should be based on your expression name or your expression in the place of [MEMBERS]

Below exp is based on the Exp name

If([No of Members]=2, Yellow(), If([No of Members] > 2, Black(), If([No of Members] <2, Red())))

or

If(Sum([MEMBERS])=2, Yellow(), If(Sum([MEMBERS]) > 2, Black(), If(Sum([MEMBERS])<2, Red())))

Either way should work