Discussion Board for collaboration on QlikView Scripting.
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:-
You may try Column1 & Column2 , this should append both of your values.
Hi Thanks - Still learning the craft.... where would this be placed in the script as I get a syntax error...
I am using
Field1 & Right ('000000' & Field2,6) as ItemCode
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)
Can you try this:
ID &0000& Left(Value,2)
if you want to use '-' between will be something as:
Try creating an expression with the above value and display it in the required chart or may be a variable.
In the attachment you could find an example.