Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hex code range...

Hi, ALL

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?

thank you.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like attached sample.

View solution in original post

4 Replies
tresesco
MVP
MVP

May be like attached sample.

Not applicable
Author

HI, treseco!

Great thank you for your reply. very helpful.

now I used it

=if(WildMatch('ㄱ',((vSearch1))),(chr(num(ValueLoop(ord('가'),ord('깋')), '(HEX)'))),'2')

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'

and

for that, do I need edit [General] Field?

now I using <Expression>.

thank you

tresesco
MVP
MVP

Though not very sure how you are trying, I guess you could use '*' concatinating with your search string. May be something like:

WildMatch('ㄱ','*' &$(vSearch1)&'*'))

If this doesn't help, please try to post your sample app.

Not applicable
Author

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