topic Re: Need Help on Color Coding as soon as possible in QlikView

Need Help on Color Coding as soon as possible

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

Hi ,

I have fileds lik this ,

My requirement is

Can anyoneplease help as it is very urgent for me

Anil_Babu_Samineni — Thu, 12 Oct 2017 03:16:14 GMT

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 — Thu, 12 Oct 2017 04:27:50 GMT

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

Anil_Babu_Samineni — Thu, 12 Oct 2017 04:31:09 GMT

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

qlikapple — Thu, 12 Oct 2017 04:35:05 GMT

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 — Thu, 12 Oct 2017 04:37:45 GMT

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 — Thu, 12 Oct 2017 05:07:22 GMT

no luck

Anil_Babu_Samineni — Thu, 12 Oct 2017 05:11:16 GMT

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

CELAMBARASAN — Thu, 12 Oct 2017 08:26:31 GMT

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

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

Either way should work