6 Replies Latest reply: Aug 27, 2015 7:29 AM by Jose Luis Dengra RSS

    SQL SELECT causes problem.

    Kamil Lewandowski

      Hello.

      My new problem with Qlikview is as following:

      I Have table in SQL with column ID that values are:

      0 01 02 03 04 05 06 07 08 09 1 10 11 12 13 3 99 (nvchar)

      I implement tables with sql select statement.

       

      But!

       

      When I load it in QV I see this table but its column has values:

      0 01 02 03 04 05 06 07 08 09 10 11 12 13 99

       

      So that QV adds '0' to single numbers even numer format is nvchar... It completely ruins my hierarchy tree. How to solve it without creating new table or using update statement (I have no access)

      counting on you!