topic Re: Text key starting with 0 in QlikView

Text key starting with 0

simonagheo — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a table with two fields: Code and Description. In this table I have the following information:

Code/Description

01/Descr1

001/Descr2

0 01/Descr3

When I select the 0 01 code, qlik returns Descr1, Descr2 and Descr3 as a description.

How can I differentiate between these codes?

PS:1. Code is also used as a key between two tables.

2. I tried text(code) and '.'@code and it doesn't work.

Thank you!

Re: Text key starting with 0

sunny_talwar — Wed, 06 Apr 2016 15:19:05 GMT

May be try this:

Dual(Text(code), RowNo()) as code

Re: Text key starting with 0

swuehl — Wed, 06 Apr 2016 15:44:46 GMT

When you are using your current script, what do you see in your list box for code? Only '0 01' ?

Then your values are interpreted as the same number, 1.

I think

Text(code) AS code

might and should work when used in the LOAD that accesses your data source.

Could you post the script code where you have tried that?

If you want to concatenate a point, use

'.' & code AS code

Re: Text key starting with 0

engishfaque — Wed, 06 Apr 2016 16:41:12 GMT

Dear Simona,

Write down listed below code in your scirpt,

RowNo() & YourFieldName as newFieldName

Kind regards,

Ishfaque Ahmed

Re: Text key starting with 0

simonagheo — Wed, 06 Apr 2016 21:22:08 GMT

Yes, in my listbox is only '0 01'

The script is:

TabA:

LOAD [Code1] AS Code,

[Description]

FROM TabA.qvd (qvd);

TabB:

LOAD [Code2] AS Code,

[OtherInfo]

FROM TabB.qvd (qvd);

I tried: TEXT([Code1]) AS Code,TEXT([Code1]) AS Code and '.'&[Code1] AS Code, '.'&[Code2] AS Code and both of them didn't work.

Re: Text key starting with 0

swuehl — Wed, 06 Apr 2016 21:33:45 GMT

I think the values are already wrong in your QVD (you can check this by examination of the QVD xml table meta data.

I believe you should apply the Text() function when you are loading from your original data source, like when loading from the SQL database.

Re: Text key starting with 0

engishfaque — Thu, 07 Apr 2016 16:02:13 GMT

Dear Simona,

You can do it by listed below script,

Dual(YourFieldName, RowNo()) As newFieldName

Kind regards,

Ishfaque Ahmed

Re: Text key starting with 0

simonagheo — Mon, 11 Apr 2016 09:54:58 GMT

In the QVDs document my script is like:

SQL SELECT *

FROM TabA;

How can I change this to accept the Text() function?

Re: Text key starting with 0

swuehl — Mon, 11 Apr 2016 23:17:19 GMT

Just use a preceding LOAD with Text() function (assuming your two fields you mentioned above. If field names differ or you need to read in more fields, just adapt accordingly):

LOAD

Text(Code) as Code,

Description;

SQL SELECT *

FROM TabA;

Re: Text key starting with 0

simonagheo — Tue, 12 Apr 2016 11:14:39 GMT

I tried this solution, but it makes weird links between Tabs A and B. I think Qlik links these tables by RowNo(), not by code.

Re: Text key starting with 0

simonagheo — Tue, 12 Apr 2016 11:15:05 GMT

I tried this solution, but it makes weird links between Tabs A and B. I think Qlik links these tables by RowNo(), not by code.