topic Re: Creating a Number in script in QlikView

Creating a Number in script

pauledrich — Thu, 05 Dec 2013 12:00:01 GMT

Hi & thanks for any help on this one.

I have the need to create a 10 digit number based on two fields - one field is always static at 4 digits and the other is a transaction ID.

So I would like to create one in the script known as 'ItemCode' the format would look something like:-

<4 digits><Padding><TransID>

Regards

Re: Creating a Number in script

bbi_mba_76 — Thu, 05 Dec 2013 12:02:44 GMT

Hi,

maybe with

<4 digits>&right('000000'&<TransID>,6)

Re: Creating a Number in script

Thu, 05 Dec 2013 12:13:00 GMT

Hi Paul,

You may try Column1 & Column2 , this should append both of your values.

Thanks,

Sai

Re: Creating a Number in script

pauledrich — Thu, 05 Dec 2013 12:30:00 GMT

Hi Thanks - Still learning the craft.... where would this be placed in the script as I get a syntax error...

I am using

Load

Field1 & Right ('000000' & Field2,6) as ItemCode

Re: Creating a Number in script

pauledrich — Thu, 05 Dec 2013 12:33:18 GMT

Thanks - I had thought of that, I want the string to be no longer and no less than 10, so 1234000012.

1234 = (Field1 Value)

0000 = (Padding - which will need to reduce as trans number increases)

12 = (Field3 Value)

Re: Creating a Number in script

Thu, 05 Dec 2013 13:00:37 GMT

Hi Paul,

Can you try this:

ID &0000& Left(Value,2)

Thanks,

Sai

Re: Creating a Number in script

angelaecheverri — Thu, 05 Dec 2013 13:01:40 GMT

Try Text(Field1&Right(('000000'&Field2),6))

if you want to use '-' between will be something as:

Text(Field1&'-'&Right(('000000'&Field2),6))

Re: Creating a Number in script

Thu, 05 Dec 2013 13:02:52 GMT

Paul,

Try creating an expression with the above value and display it in the required chart or may be a variable.

Thanks,

Sai

Re: Re: Creating a Number in script

bbi_mba_76 — Thu, 05 Dec 2013 13:21:46 GMT

In the attachment you could find an example.