topic Re: hex code range... in QlikView

hex code range...

Fri, 17 Jan 2014 09:16:08 GMT

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.

tresB — Fri, 17 Jan 2014 09:57:46 GMT

May be like attached sample.

Mon, 20 Jan 2014 02:11:31 GMT

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

tresB — Mon, 20 Jan 2014 07:16:30 GMT

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.

Tue, 21 Jan 2014 05:16:27 GMT

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