difference between 1 and 001

[Anonymous]

Hello,

I have a problem with 0 bevore number in data mart (QV 11.2 SR3).

First I load from SQL a table with profit accounts. In this table there are two accounts 12345 and 0012345. Aftewards I load a table with values and join to the accounts table. The table with values has accounts 12345 and 0012345 too.

The problem: QlikView doesn't make difference between this accounts, shows in front end only 0012345 with count 2 and maps the values to both accounts cross over.

In script I define the format of the account field as Text(). Without success.

Any Ideas?

[Anonymous]

Unfortunately is it the right solution. I expected more intelligence from QlikView.

The script command Text() doesn't always work (see below). If I easy load account list and calculate, it works fine.

In my case I loaded the account list at the first step from SQL parent child table with hierarchybelongsto command.

Here doesn't work the commant Text(). Finally I used the tip above in the SQL statement. It is ok now.