There's something not right here:
Pick(Wildmatch(Search_Type,'C','CP','CX','C','CP','CX',''),'Active','Active','Inactive','All','All','All','All') as ActiveInactiveFlag
If you want a wildmatch you need to use wildcards in your expression so the expression knows exactly how to compare strings. We need to be careful, if you replace 'C' with 'C*' for example then if Search_Type = 'CP' the wildmatch function will not return 2 but 1 because 'C*' is a wildmatch with 'CP'.
Instead of trying to return a value of 7 for a wildmatch with '' take out the '' parameter and add 1 to the wildmatch and rearrange your pick selections.
So instead of something like
Pick(Wildmatch(Search_Type, 'A*','B*','C*',''),'A...','B...','C...', 'Nothing')
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.
flag.qvw 152.2 K
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.
I think neha.shirsath is right her code is working lets check:
LOAD * Inline [
If(wildmatch(Search_Type,'CX'),'Inactive')) as ActiveInactiveFlag
DROP Table test;
LOAD * Inline