10 Replies Latest reply: Jan 9, 2014 8:02 AM by Dimitri Obrant RSS

    difference between 1 and 001

    Dimitri Obrant

      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?