Discussion Board for collaboration on QlikView Scripting.
I searching for solution about expression.
now i used this for present hex code.
=if(WildMatch ((chr( num#( 'AC00', '(hex)') )),((vInput))) ,'1','2')
ex. I wrote 'ㄱ' in input box, '1' appeared in Text Object which is written THAT EXPRESSION.
so, I want it. If I write the 'ㄱ', list box shows values corresponds to condition( like AC00~B097).
All data is irregular.
Once expression is right, I can show values in list box.
How I can write expression?
Go to Solution.
May be like attached sample.
Great thank you for your reply. very helpful.
now I used it
I put the 'ㄱ' in input box, and then I want to extract words including from'*가*' to '*깋*' (hex range) in a specific field.
I cant use '*' in expression. appear 'Error'
for that, do I need edit [General] Field?
now I using <Expression>.
Though not very sure how you are trying, I guess you could use '*' concatinating with your search string. May be something like:
If this doesn't help, please try to post your sample app.
seems to be solved!
I think function I tried to implement need to be excepted.
except that, almost done
your advice was very helpful.
thank you , tresesco