5 Replies Latest reply: Jun 6, 2016 2:56 PM by Philippe Grenier RSS

    QlikSense ErrorMode Issue

    Alec Harf

      hi all,


      Anyone has an issue with using QlikSense ErrorMode? after I upgraded to 2.2 it doesnt work and i get an error even I set it to:


      Set ErrorMode=0;


      Let me know..

        • Re: QlikSense ErrorMode Issue
          Sunny Talwar

          I have Qlik Sense 2.2




          And I tried this and it ran


          SET ThousandSep=',';

          SET DecimalSep='.';

          SET MoneyThousandSep=',';

          SET MoneyDecimalSep='.';

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

          SET TimeFormat='h:mm:ss TT';

          SET DateFormat='M/D/YYYY';

          SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

          SET FirstWeekDay=6;

          SET BrokenWeeks=1;

          SET ReferenceDay=0;

          SET FirstMonthOfYear=1;

          SET CollationLocale='en-US';

          SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

          SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

          SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

          SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';


          SET ErrorMode = 0;



          LOAD * INLINE [

          Dim, Sales

          A, 50

          B, 100



          Resident: // Error portion just to check if it bypass the error or not

          LOAD a,


          Resident Table;

          • Re: QlikSense ErrorMode Issue
            Alec Harf

            looks like not many people play with Sense Server..:)

            • Re: QlikSense ErrorMode Issue
              Philippe Grenier

              I am experiencing the same issue while trying to load a web table that doesn't exist:



              Launching the same statement on a stock that exists works fine (replace THI.TO with SLW.TO for example)


              I have added the SET ErrorMode = 0; statement before executing the LOAD, but the script still crashes rather than ignoring the error.


              Would anyone have any ideas?