condition not working

[kishorj1982]

Hi all,

the below condition is not working.Please suggest

Pick(match(Search_Type,'C','CP','CX','C','CP','CX',''),'Active','Active','Inactive','All','All','All','All') as ActiveInactiveFlag,

[shraddha_g]

Try

Pick(Wildmatch(Search_Type,'C','CP','CX','C','CP','CX',''),'Active','Active','Inactive','All','All','All','All') as ActiveInactiveFlag,

[Anil_Babu_Samineni]

What is this indicated in your match() -- ''

[kishorj1982]

For all condition need to values for all flags  c cp cx and blanks

for active value need to show value  for flag c, cp and

for inactive need to show value for flag  cx

plz suggest

[Anil_Babu_Samineni]

Try this way

Pick(WildMatch(if(len(trim(Search_Type))=0,'0',Search_Type), 'C','CP','CX','C','CP','CX','0'),'Active','Active','Inactive','All','All','All','All') as ActiveInactiveFlag

[arvind_patil]

Hi Kishor,

May be like this:

If(wildmatch(Search_Type,'C','CP'),'Active',

If(wildmatch(Search_Type,'CX'),'Inactive','All')) as ActiveInactiveFlag,

Thanks,

Arvind Patil

[kishorj1982]

Hi Arvind,

For All, I nned to show the value for c,cp,cx and blank

[kishorj1982]

Hi all ,

For Option all need to show values for c cp cx and blanks

for option active value for c, cp  need to display and

and for option inactive value for cx need to show in list box.

Please suggest.

PFA.

[tresesco]

Your conditions are not mutually exclusives, i.e they overlap. If first condition is true for say 'c' to be 'Active', it would never be true for 'All'. Here you could follow Generic keys that would require multiple loads for Search_Type data. 

[neha_shirsath]

Hi,

Please find the attached file.