topic numeric variable in alphanumeric in QlikView

numeric variable in alphanumeric

Fri, 23 Oct 2009 20:28:57 GMT

Hi,

I have a question:

from a database field numbers (like 2, 0) and importing it into qvw if the first digit is a number ,

becomes 1 instead of 01 or 2 instead of 02 ... etc. ..

My solution when I do the load:

Repeat ('0 ', 2 - Len (Text (Num # (Variable, '00')))) & Text (Num # (Variable, '00')) as variable1;

ok ...

ok ... the "text" and "num" are not going well in this case

There is a more "simple"?

Thanks

numeric variable in alphanumeric

Fri, 23 Oct 2009 21:02:19 GMT

Hi William,

ia´m not sure if i understand your question correctly.

But this works for me:

Num

(

Be aware that the NUM function only works to 13 or 14 digits.

You can use in cases like this EVALUATE but without decimals.

See the attached file as an example for this.

Rainer

Numbers, '000000') as NewNumbers

numeric variable in alphanumeric

Fri, 23 Oct 2009 21:21:45 GMT

Sorry,

I mean:
I have a numeric variable containing:

01
02
03
04
...

importing into QlikView me becomes:

1
2
3
4

whereas I would like him to stay:

01
02
03
04

but withe command text or num not like...

Thanks

numeric variable in alphanumeric

Fri, 23 Oct 2009 21:25:24 GMT

Try it

ArticoliNew:
Noconcatenate
LOAD text(CODICE) as CODICE,
DESART
resident Articoli;

Daniela

numeric variable in alphanumeric

Fri, 23 Oct 2009 21:36:28 GMT

I already tried

Text (variable)

but since the variable is defined numeric, text has no effect ..

numeric variable in alphanumeric

Fri, 23 Oct 2009 23:31:02 GMT

left('00',2-len(Variable)) & Variable as Variable1

not quite the most elegant solution, but it's a bit more simple.