Discussion Board for collaboration on QlikView Scripting.
i wanted to create a keyword field from 1 of my existing field. The existing field is business_description where it contains long desvcription.
So i want to create a keywords list box, pick up some words from each of the description .
at the loading script, i've wrote.
If ( business_desc = '*Food*' , 'About Food' , Null() ) as Keywords.
When I loaded the script, i have found that the keywords list box is empty! no data!
So, my script is wrong?
Solved! Go to Solution.
I realised there's a description like - Chili Chicken and another one is Chili Paste Chicken.
I need to create a keyword that it can find both of this description. Can i write:
if ( business_desc like '*Chili* + '*Chicken*' , 'Spicy Chicken' , Null() ) as Keywords
can you please post some different examples of your source strings and keyword combinations as well as your expected result to create a sample application with?
here's the screenshot. i have also attached sample data.
Here's my script :
If ( survey_desc like '*lamb*' , 'lamb' ,
If( survey_desc like '*chili**CHICKEN*' , 'chili chicken' ,
If( survey_desc like '*chicken**beef**lamb*' , 'chicken and beef and lamb' ,
Null() ))) as keywords
drop table survey;
now this one is not functioning - If( survey_desc like '*chicken**beef**lamb*' , 'chicken and beef and lamb'.
i want to have when user choose chicken and beef and lamb from the listbox, then it should show me desriptions that has chicken,beef and lam words.