31 Replies Latest reply: Apr 23, 2014 11:25 AM by Philip Lima RSS

    Loading problem with 10 Qlikwiew

    Francesco Fiorillo

      Hello.
      It happens to me a strange thing.
      With the release of version 10, I started to try the applications already made.
      I had no problem, except for an application for which I can not reload the script as though not getting any error message from the variables, and showing that you have loaded the data, in the end I said:
      Running the script failed. Load the previous data?
      I have tested.
      1. I tried to load only part of the script. To a certain extent is fine, then randomly just add another sheet of the script gives me the error persists, oddly enough, even if I delete the package you just added.
      2. I tried to export the presentation of the document and to import it into a new document. Well. The data load is successful only the first time, then I always get the same error.
      I think there are dirty data. In the script, do not use anything special. Can I assume that would be the command RESIDENT (I have several).
      Could you please give me a hint?

      thanks in advance for your cooperation

        • Loading problem with 10 Qlikwiew
          Karl Pover

          Are you using inputfields? I've had trouble with inconsistent script errors when using inputfields. I would just receive the "Script failed. Load previous data?" at the end of the script. I found that I have to load the script without inputfields first and then with inputfields for it to work.

          Have you generated the script log files?

          Regards.

          • Loading problem with 10 Qlikwiew
            Erich Shiino

            Were you all able to make inputfield to work on QV 10 SR1?

            I moved the inputfield definition to the end, but it didn't help.

            I can use my field as regular field, but list boxes or straight tables do not allow me to change the number anymore.

            Inputsum returns null for me in any case.

            Please, I'd like to know more about your experiences.

            Did you contact QlikTech support about it?

            Rgds,

            • Re: Loading problem with 10 Qlikwiew
              Alexandre Lourenço

              Sorry but I know that's a long time that anyone put something here but I'm new in this Community and I'm facing this problem in QV10.

               

              I put InputField before and then in the end of the Script and It didn't work.

               

              I have no problems by Reload but I can't put any value at my "InputField Field".

               

              May you help me?

               

              I've tried it in two ways.

              The first one, I can't put any value in InputField

              The second, If I put any value, it give an error like the image.

               

              1 -

              Priorização:

              LOAD //Module as %Module,

                   //Status as %Status,

                   //[by Dept.],

                   //[Reported by user],

                   Number,

                   //Subject,

                   //Motivation,

                   //[Prioridade Anterior],

                   //[Current Responsible],

                   Anterior,

                   0 as Prioridade,

                   RowNo()

                

              FROM

              [lalalalalalalalalala\Atualização.xlsx]

              (ooxml, embedded labels, table is Sheet1);

               

               

              INPUTFIELD Prioridade;

               

              2 -

               

              INPUTFIELD Prioridade;

               

              Priorização:

              LOAD //Module as %Module,

                   //Status as %Status,

                   //[by Dept.],

                   //[Reported by user],

                   Number,

                   //Subject,

                   //Motivation,

                   //[Prioridade Anterior],

                   //[Current Responsible],

                   Anterior,

                   0 as Prioridade,

                   RowNo()

                

              FROM

              [lalalalalalalalalalalalalala\Atualização.xlsx]

              (ooxml, embedded labels, table is Sheet1);

               

               

               

              Error.png

              • Re: Loading problem with 10 Qlikwiew

                I think schiesslr nailed it with his point 1. This should explain why some many people here are having an issue. It's not that QV10 has a bug, it's that with the QV10 release the user is warned that they are making a mistake in their data model.

                 

                Make sure the table that contains the input field has a unique key. If not you will get the "Duplicate keys" error. Think of it in this way:

                 

                Qlikview is bacially storing a value unique to the row in your table. If there is no single column that uniquely defines a row, then QV has no way to properly determine which row it should update. The core idea with input fields is that your input value should only modify one row. This is why so may people are finding a solution by adding the RowNo() function as the last column in thier table - because this create a unique ID for the row that did not exist before.

                 

                My opinion is that adding RowNo() is an incorrect solution and you should really look at your data model and understand what your primary key should be on the table you are attempting to add input fields to. Most probably this investigation will yield a much more valuable primary key than an arbitrary RowNo().