Like query in qlikview

[capriconuser]

i have column where data is like this 

abc123

abc345

abc789

def234

def908

def9239

now i am trying to create filters like if

if(Substringcount(Column1,'abc'),'Value1_abc','Value2_def')

user select value1_abc from table then this show select all abc data which is starting from abc and if user select value2_def then this should be select all def data how i do this 

[albert_guito]

Hi,

may be it better add a new field in you data set like:

Load *, Left(data,3) as Category Inline [data
abc123
abc345
abc789
def234
def908
def9239
];

[mkiran_18]

May be it will help you 

Test:
LOAD *,
if(WildMatch(FIELD_1,'abc*')>0,FIELD_1,Null()) as FIELD_2,
if(WildMatch(FIELD_1,'def*')>0,FIELD_1,Null()) as FIELD_3;
LOAD * INLINE [
FIELD_1
abc123
abc345
abc789
def23
def908
def239
];