2 Replies Latest reply: Mar 10, 2014 6:57 AM by Jasper Ennik RSS

    General Script Error caused by group where concatenation

    Jasper Ennik

      While developing a QlikView report I came across a "general script error" caused by a WHERE clause in a grouped load. It's reproducable using the script pasted below. If I enable logging, the logfile does not contain any more details as to why this error is thrown.

       

      Have I encountered a bug, or is there a logical reason why this shouldn't work?

       

      In the meanwhile I've found a workaround by first constructing a second NoConcatenate table, which I then later concatenate and drop in consecutive separate statements.

       

      NoConcatenate

      Tab1:

      LOAD * INLINE [

      FactRowNo, Factor

      1, 0.5

      1, 0.3

      2, 1

      3, 0.9

      ];

       

       

      Concatenate (Tab1)

      LOAD

        1-SUM(Factor) As Factor,

        FactRowNo

      WHERE

        1-SUM(Factor) > 0

      GROUP BY

        FactRowNo;

      LOAD * RESIDENT Tab1;

       

       

      LogFile:

      10/03/2014 11:37:56:       General Script Error

      10/03/2014 11:37:56:       Execution Failed

      10/03/2014 11:37:56:      Execution finished.