Only marked Value

[subbareddykm]

Hi ,

I have one field Which is consist diff values,in that i want only Q1,Q2,Q3,Q4

How to get this?

[Chanty4u]

can u explain more?

[Chanty4u]

u mean default selections or always one selectd values?

[subbareddykm]

What i want is

if Q1-F12,  Q2-F12,  Q3-F12,  Q4-F12, is there ,i want only Q1,Q2 Q3 Q4;

also I want What selected in the Screenshot.

[arulsettu]

try this

if(Match(quarters,'Q1','Q2','Q3','Q4'),quarters) as new

[subbareddykm]

H

50% okay

Its picking only Q1,Q2 Q3 Q4;

also i want

if Q1-F12,  Q2-F12,  Q3-F12,  Q4-F12, is there ,i want only Q1,Q2 Q3 Q4;

also I want What selected in the Screenshot.

[sunny_talwar]

Do you just want to filter out Q1-F12 from the list box or do you want to rename them to Q1?

If renaming, then may be this:

Pick(WildMatch(Quarter, 'Q1*', 'Q2*, 'Q3*', 'Q4*'), 'Q1', 'Q2', 'Q3', 'Q4')

[Chanty4u]

LOAD *, if(wildmatch(Quater, '*'&Q1&'*') or wildmatch(Quater, '*'&Q2&'*'),1,0) AS Flag

try lik dis