- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Creating listbox with SQL Like Statement
Experts,
Currently my scripts as follows
LOAD No,
PID,
SDATE,
TCCODE,
DESCRIPTION,
QUANTITY,
UOM,
RATE,
CURRENCY,
PRICE,
REPRESENTATIVE
FROM
(ooxml, embedded labels, table is APR2016 )where DESCRIPTION like '*32*';
When I analyse the field values I have values NODE 44232, DAILY BC 32, MONTHLY BC32, MONTHLY BC-32 etc
I need to query BC 32, BC32, BC-32 only. Like '*32*' is not suitable.
Also instead of putting the statement in Load, I would like to have a listbox (Expression) with a Single SQL Like statement where user can select.
What is the expression I should use in Listbox?
Thanks
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe
LOAD No,
PID,
SDATE,
TCCODE,
If(Wildmatch(TCCODE,'*BC32*','*BC 32*','BC-32*'),'Find *BC32* or *BC 32* or *BC-*32') as FindTCCode,
DESCRIPTION,
QUANTITY,
UOM,
RATE,
CURRENCY,
PRICE,
REPRESENTATIVE
FROM
(ooxml, embedded labels, table is APR2016 );
Then use FindTCCode in a list box and make the selection to filter.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=Aggr(if(Match(TCCODE, 'BC 32', 'BC32', 'BC-32'),TCCODE), TCCODE)
-Rob
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
(ooxml, embedded labels, table is APR2016 )where DESCRIPTION like '*32*' and DESCRIPTION like '*BC*';
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
or maybe
where DESCRIPTION like '*BC*32*';
regards
Marco
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Rob,
My Apologies if I have not made my request clear.
I have added a list box and in Field I should choose TCCODE or Create an Expression and Enter
=Aggr(if(Match(TCCODE, 'BC 32', 'BC32', 'BC-32'),TCCODE), TCCODE)
-Rob
I tried as follows (Expression) Contains above code you have suggested.
But What I am looking forward is as follows. A List Box lists specific keywords to search. Upon Selecting this listboxitem,, a Table shows all fields and TCCODE filed with string matches the selection will be displayed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Marco. I do not wish to put this in Load statement. I would prefer to have them listed in a list box. How do I do it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Enrique.
I do not wish to put this in Load statement. I would prefer to have them listed in a listbox. How do I do it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where are the list box values coming from if not loaded?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In the QlikView UI there is no real SQL-like query langiuage available, but the very powerful Search function offers you much of the same functions and advantages.
Do a search for specific wildcard values in the regular TCODE listbox, and create a bookmark with a proper name. Then create a Bookmarks object and it will show a list of those predefined searches.
Best,
Peter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Go To list box properties -> instead of selecting Field for LB, write expression ->
If(Description like '*32*', Description)
- « Previous Replies
-
- 1
- 2
- Next Replies »