topic Re: Like query in qlikview in QlikView

Like query in qlikview

capriconuser — Mon, 21 Jan 2019 10:52:18 GMT

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

Re: Like query in qlikview

albert_guito — Mon, 21 Jan 2019 11:25:00 GMT

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
];

Re: Like query in qlikview

mkiran_18 — Mon, 21 Jan 2019 11:34:54 GMT

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
];