9 Replies Latest reply: Apr 30, 2012 7:13 AM by mark yang RSS

This is Bug Issue ?

mark yang

Anyone can help me fix this problem ? When I load data from database, I have a field (the value is A,1,N1,B,01,N2),But when you load,the value will be change to A,1,1,B,1,N2.

LOAD * INLINE [
Group_ID, Group_Name
A, one
1, two
N1, three
B, four
01, five   
N2, six
];

another script has different problem,just show 4 records

LOAD * INLINE [
Group_ID, Group_Name
A, A
1, 1
N1, N1
B, B
01, 01   
N2, N2
];

  • This is Bug Issue ?
    the fourth

    Try usign Text():

     

    LOAD text(vGroup_ID) as Group_ID, * INLINE [

    vGroup_ID, Group_Name

    A, one

    1, two

    N1, three

    B, four

    01, five

    N2, six

    ];

     

    Regards

  • Re: This is Bug Issue ?
    Celambarasan Adhimulam

    Hi,

         By default qlikview recognizes its a number then make it to number format.

         Here you 01 which is number so it makes it as 01.If you need as it is you have to use text()

     

    LOAD Text(Group_ID) as Group_ID, Group_Name INLINE [

    Group_ID, Group_Name

    A, one

    1, two

    N1, three

    B, four

    01, five   

    N2, six

    ];

     

    LOAD Text(Group_ID) as Group_ID, Text(Group_Name) as Group_Name

    INLINE [

    Group_ID, Group_Name

    A, A

    1, 1

    N1, N1

    B, B

    01, 01   

    N2, N2

    ];


    • Re: This is Bug Issue ?
      mark yang

      Why 1,01 and N1 is the same? 1 and 01 is the sam. I can accept it, but N1 ?

      The other question, when I load data from database , if Group_ID is varchar type, it's seem has the same problem. So I need add Text() at all fields ? When the application get the data structure, it can analysis which fields is text type. Why don't set it to default ?

      QlikView Ver.  11.00.11282.0409

      testError.jpg2012-04-30 15-28-28.jpg

      2012-04-30 15-34-29.jpg2012-04-30 15-39-59.jpg

      • Re: This is Bug Issue ?
        Henric Cronström

        I have attached a picture of the data that I get when I run your script.

         

        In it you can see that N1 does not change value. You can also see that when QlikView has interpreted a field value as a number, it will by default be right-aligned, whereas a text will be left-aligned. I.e. a single field can have a mix of text and numbers. If you want to force QlikView to always interpret the field numbers as text, then you should use the Text() function as Celambarasan suggests. But it is not what you want as default, since many fields indeed are numeric.

         

        HIC

      • This is Bug Issue ?
        Henric Cronström

        I can see that also N2 is interpreted numerically (right-aligned) so something in your script makes N1 and N2 be interpreted as numbers - which they shouldn't be. Can you post your application?

         

        HIC

        • This is Bug Issue ?
          mark yang

          This is my system info.

          =========================   Document Info   ==========================

          Document                           E:\Sample Data\Revenue\testError.qvw

          Connection                         Local

          DecimalSep                         Doc="."(2E)       Sys="."(2E)

          ThousandSep                        Doc=","(2C)       Sys=","(2C)

          ListSep                            Doc=","(2C)       Sys=","(2C)

          MoneyDecimalSep                    Doc="."(2E)       Sys="."(2E)

          MoneyThousandSep                   Doc=","(2C)       Sys=","(2C)

          MoneyFmt                           Doc="NT$#,##0.00;-NT$#,##0.00" Sys="NT$#,##0.00;-NT$#,##0.00"

          TimeFmt                            Doc="hh:mm:ss"    Sys="hh:mm:ss"

          DateFmt                            Doc="YYYY/MM/DD"  Sys="YYYY/MM/DD"

          TimestampFmt                       Doc="YYYY/MM/DD hh:mm:ss[.fff]" Sys="YYYY/MM/DD hh:mm:ss[.fff]"

          Document File Format               0 (6000)

          Saved in Version                   11.00.11282.0409

          Client NT Name                    

          Access                             ADMIN

          License                            -

          Document License Status            ALLOWED

          =======================   Object Cache Info   ========================

          Object Cache Limit (MB)            786.18

          =========================   QlikView Info   ==========================

          Client Build Number                11.00.11282.0409

          Server Build Number                -

          QlikTech Product                   QlikView 64-bit Edition (x64)

          License Key                        [Personal Edition]

          PE Recoveries Remaining            0

          CPU Target                         x64

          ===========================   INI Values   ===========================

          BookmarkDocument                   1

          CanDynamicUpdate                   1

          CollabPaneSplitPrecentage          0.182222222222222

          CollabPaneVerticalSize             160 740

          CurSelFirstColWidth                71

          CurrentQVConnect32Loc              C:\Program Files (x86)\QlikView\QvConnect32.EXE

          CurrentQVConnect64Loc              C:\Program Files\QlikView\QvConnect64.EXE

          DebugDlgHeight                     818

          DebugDlgWidth                      1600

          DefaultRefLineColor                33587200

          DefaultRefLineWidth                4

          DontShowConfirmToShowStartPageAgain 1

          ExpOvwColWidths                    60,144,60,365,120,100,180,300

          FirstUserExperience                0

          HatchedBrushes                     0

          InstalledLIBID110                  {15B258E8-415E-11D1-934D-0040333C91CC}

          InterfaceLanguage                  English

          LA_SmoothLine                      1

          LastViewedUpdate                   384B8F6E-487F4CAB-AC50CA74-1318D3FA-94297A25

          LoadFollowing                      1

          MarginTop                          20

          NextWebUpdateDate                  41028

          SMTP_Address                       marky@accton.com.tw

          SMTP_Encoding                      utf-8

          SMTP_MIME                          1

          SMTP_Name                          mark

          SMTP_Server                        mail2

          SavedCustomColors                  FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF

          ShowStartPageOnStartup             0

          ShowSystemTables                   0

          ShowSystemVariables                1

          ShowUserDsn                        1

          ShowWizIntroThemeMaker             0

          Utf8FileDlgPathOpenDoc             E:\Sample Data\Revenue2\

          Utf8FileDlgPathSaveDoc             E:\Sample Data\Revenue

          =======================   Local System Info   ========================

          Operating System                   Windows 7 Ultimate Service Pack 1 (64 bit edition)

          Operating System Version           6.1.7601

          Wow64 mode                         Not using Wow64

          IE Version                         9.0.8112.16421

          MDAC Version                       6.1.7601.17514

          MDAC Full Install Version          6.1.7601.17514

          ComCtl32 version                   6.16.7601

          Current Theme                      C:\windows\resources\themes\Aero\Aero.msstyles

          Graphics 1                         1600*900 pixels. 1 Monitors.

          Graphics 2                         32 Bit Color Depth. 96 XDpi. 96 YDpi.

          Local Time                         2012-04-30 18:34

          GMT Time                           2012-04-30 10:34

          Country                            886 台灣 Taiwan

          Language                           0404 中文 (繁體,台灣) Chinese (Traditional)

          Physical RAM(MB)                   7861

          VMCommitted(MB)                    55

          VMAllocated(MB)                    317

          VMFree(MB)                         2010

          VMLargestFreeBlock(MB)             2010

          Number of CPUs                     4

          CPU 0                              Intel(R) Core(TM) i5 CPU       M 540  @ 2.53GHz 2526MHz

          CPU 1                              Intel(R) Core(TM) i5 CPU       M 540  @ 2.53GHz 2526MHz

          CPU 2                              Intel(R) Core(TM) i5 CPU       M 540  @ 2.53GHz 2526MHz

          CPU 3                              Intel(R) Core(TM) i5 CPU       M 540  @ 2.53GHz 2526MHz

          • Re: This is Bug Issue ?
            flipside

            It's the formatting of your currency causing it - I have replicated the error.  Change it to $ only and it loads fine.

             

            flipside

             

             

            EDIT:

             

            Like this ...

             

            SET MoneyFormat='$#,##0.00;-$#,##0.00';

             

            ... this sounds like a bug as your currency format is being picked up from your system settings, but you should be able to work around it now.

             

            EDIT 2:

            Can you use something like the following to get round it (in all your documents)

             

            SET MoneyFormat='(NT)$#,##0.00;-(NT)$#,##0.00';

          • This is Bug Issue ?
            Henric Cronström

            I can reproduce this problem on my computer now. It is caused by the number format in the script. If you change the line where it says

               SET MoneyFormat='NT$#,##0.00;-NT$#,##0.00';

            to

               SET MoneyFormat='$#,##0.00;-$#,##0.00';

            then it will work properly

             

            I will raise this issue as a potential bug in our system.

             

            HIC