topic Re: Every other LET variable fails in QlikView

Every other LET variable fails

Fri, 11 Jul 2014 01:49:21 GMT

I am trying to create a script file of the world's currency symbols and am assigning variables to the hex code. For some reason every other variable isn't recognized and fails in the reload. They don't even turn blue. See picture below:

Can anyone see the problem? I assume the syntax for the symbol works since the blue variables work in text boxes.

Thanks in advance!

Re: Every other LET variable fails

Fri, 11 Jul 2014 02:00:15 GMT

The expression in the num#() function is not properly constructed, you have 3 single-quotes.

The format should be num#('4c', '(hex'))

Re: Every other LET variable fails

Fri, 11 Jul 2014 02:07:52 GMT

What is the target state of vALLSymbol? Should it be 'Lek'? If so, you might want to try something like this:

Let vALLSymbol = chr(num#('4c', '(hex)')) & chr(num#('65', '(hex)')) & chr(num#('6b', '(hex)'));

Re: Every other LET variable fails

Fri, 11 Jul 2014 15:29:36 GMT

Ah you're right. I created the formula in excel and it used that single quote to format the end of the function as text and was lost in concatenation. Thanks for your help!

My end result is to have a list of all currency symbols, e.g. $, €, ¥.

Re: Every other LET variable fails

rbecher — Fri, 11 Jul 2014 15:32:47 GMT

Why not using the decimal value and chr() instead of hex?

Re: Every other LET variable fails

Fri, 11 Jul 2014 15:43:43 GMT

There was no specific reason. Mainly used hex because I knew it worked in that format, I didn't know that chr() used the decimal format. I think I am going to end up using decimal since it looks cleaner and there is less computing necessary.