Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator II

condition not working

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,

19 Replies
shraddha_g
Partner - Master III
Partner - Master III

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kishorj1982
Creator II
Creator II
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
arvind_patil
Partner - Specialist III
Partner - Specialist III

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
Creator II
Creator II
Author

Hi Arvind,

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

kishorj1982
Creator II
Creator II
Author

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
MVP
MVP

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
Specialist
Specialist

Hi,

Please find the attached file.