topic QlikSense ErrorMode Issue in App Development

QlikSense ErrorMode Issue

alec1982 — Sat, 07 May 2016 06:44:42 GMT

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 — Sat, 07 May 2016 08:55:35 GMT

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;

Table:

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

alec1982 — Sat, 07 May 2016 09:07:26 GMT

hi Sunny,

I think you are trying the desktop version while the issue is on the server version.. I also upgraded to 2.2.4 and still have the same issue...

Re: QlikSense ErrorMode Issue

sunny_talwar — Sat, 07 May 2016 09:10:00 GMT

That could be it. I am working on the desktop version. My apologize.

Best,

Sunny

Re: QlikSense ErrorMode Issue

alec1982 — Mon, 09 May 2016 17:34:27 GMT

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

Re: QlikSense ErrorMode Issue

pgrenier — Mon, 06 Jun 2016 18:56:21 GMT

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

real-chart.finance.yahoo.com/table.csv?s=THI.TO&a=03&b=18&c=2014&d=04&e=01&f=2016&g=d&ignore=.csv

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?