topic Re: Load script with multiple columns in QlikView

Load script with multiple columns

Mon, 26 Jan 2026 18:19:17 GMT

Hi Dear Commutity,

Thank you for check on my post ,

I am a newer on QlickView,

and I had a problem in this case,Could you like to give some suggestions?

LOAD
A,
B,
A & ‘:’ & B as C

INLINE [
A,B
101, 121
103, 001
]

The result is
A B C
101 121 101:121
103 001 101:121 There should be (103:001) as I thought

The result of 103 is wrong,but when I change ‘:’ to other symbol like ‘_’ the result is right,

I want to find some suggestions for why this might occur I would suggest.

Thank you again for any suggestions!

Re: Load script with multiple columns

sunny_talwar — Wed, 30 Mar 2016 11:15:27 GMT

I see the right result:

Script:

Table:

LOAD A,

A & ':' & B as C

INLINE [

A,B

101, 121

103, 001

]

Re: Load script with multiple columns

Wed, 30 Mar 2016 11:25:28 GMT

I got right result.

Thank you.

Re: Load script with multiple columns

Chanty4u — Wed, 30 Mar 2016 11:31:15 GMT

the code is correct it is showng exctly.

try to chk ur code once and reload again.

Re: Load script with multiple columns

Thu, 31 Mar 2016 00:16:24 GMT

Hi Sunny

Thank you for your code,

It's weird , I tried your qwd on my computer ,

But It isn't work for me.

The result is still ><

A	B	C
101	121	101:121
103	001	101:121

Re: Load script with multiple columns

Chanty4u — Thu, 31 Mar 2016 06:26:23 GMT

COOOOOOOL

please close this thread by making correct and helpful answers.

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Load script with multiple columns

Thu, 31 Mar 2016 07:19:18 GMT

I was also getting the same result like you . But finally sort it out either by converting resultant field C to

number or text.

See the attached .

Re: Load script with multiple columns

sunny_talwar — Thu, 31 Mar 2016 08:50:47 GMT

What version of QV are you using? May be an old bug?

Re: Load script with multiple columns

Thu, 31 Mar 2016 09:27:56 GMT

Hi Sunny,

As you said it might be a bug. I am using 11.0 SR1 version QV.

Re: Load script with multiple columns

Thu, 31 Mar 2016 09:40:01 GMT

Qlikview see this data as timestamp formatting.

So 101:121 is equal to 103:001. 121 means 2*60 + 1

Re: Load script with multiple columns

Anonymous — Thu, 31 Mar 2016 09:41:50 GMT

It is right you must get the answer

other wise you try this one

Table:

LOAD A,

A & ':' & B as C

INLINE [

A,B

101, 121

103, 001

]

Re: Load script with multiple columns

Peter_Cammaert — Thu, 31 Mar 2016 09:46:58 GMT

The probable cause of this code working for some and not working for others, is that the colon-character may be used to implicitly interprete values as something else (like a time value).

QlikView contains a lot of internal conversion code that tries to recognize and convert values from one format into another. All behind the scenes and purely for performance reasons (QlikView really is quick!) Classical cases are time and date values that suddenly display other string representations because the underlying numerical value is identical and in a symbol table every single numerical value can only have one string representation.

In your case, after string concatenation 101:121 is treated as a time (hh:mm) value. In minutes (this is not the internal representation but the logic is the same) this comes down to a value of 101*60 + 121 = 6181.

The other string 103:101 is also treated as a time value and converted to 103*60 + 001 = 6181. However, because this value already exists in the field symbol table, it will not get a new string representation. The first one will survive.

You should get the exact same result with values 102 and 061.

Solution: do not create strings or key fields that may look to QlikView like timestamps, dates, or numerical values, as QlikView will most certainly try to convert them to a numerical value behind your back. Add a character in front, or change the colon into something else (like a vertical bar | ). Never use colons or dots in the construction of key values as you will most certainly be in serious trouble.

Peter

Re: Load script with multiple columns

Mon, 04 Apr 2016 00:16:32 GMT

Hi Peter

Thank you for your reply,It's very helpful,

It was a bad idea to use a colon in the construction of key values,

I will never do it again in my code,

Yumi