
Creator
2019-01-21
05:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Like query in qlikview
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
596 Views
2 Replies

Creator II
2019-01-21
06:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
];
Ag+
591 Views

Contributor III
2019-01-21
06:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
];
588 Views
