topic Re: Inline script is not work properly in QlikView

Inline script is not work properly

Wed, 01 Jul 2015 03:34:39 GMT

Hi,

I try to make table in line, but unfortunatelly when I push the reload button suddenly show the error message:

"syntax error, Missing/misplaced FROM:

DimentionList:

LOAD * Inline [

%Dimentions

SalesPerson

Country

City

Product

];

i really dont have idea about this problem, because any people also write like that, but in my case show error message.

Thank you for your help and attention.

Re: Inline script is not work properly

sunny_talwar — Wed, 01 Jul 2015 03:36:54 GMT

It worked for me. Would you be able to share the logfile?

Re: Inline script is not work properly

sunny_talwar — Wed, 01 Jul 2015 03:37:49 GMT

See if you get the same error, when you refresh the attached application:

Best,

Sunny

Re: Inline script is not work properly

qlikviewwizard — Wed, 01 Jul 2015 03:41:49 GMT

Do you need %? For me there is no issue. Do you have other script after this?

Use the below script and if you get any error let me know.

DimentionList:

LOAD * Inline [

Dimentions

SalesPerson

Country

City

Product

];

EXIT Script;

Re: Inline script is not work properly

Siva_Sankar — Wed, 01 Jul 2015 03:44:20 GMT

Try checking the spaces or create a new document and type manually again the script and reload. Check if there are any unwanted characters standling alone below or above the script. Better try recreating a new file and check

Re: Inline script is not work properly

prashantbaste — Wed, 01 Jul 2015 03:58:27 GMT

Its seems no error in code -

LOAD * INLINE [

%Dimentions

SalesPerson

Country

City

Product

];

There is chance of error in above/below code. You can try same piece of code in another/ fresh application & check.

Regards,

Prashant P Baste

Re: Inline script is not work properly

Wed, 01 Jul 2015 03:58:58 GMT

Thank you for your reply,

how can i find logfile.

Yhx

Re: Inline script is not work properly

Wed, 01 Jul 2015 04:00:25 GMT

yes i need it,

in order to make dynamic adhoc.

Thx

Re: Inline script is not work properly

Siva_Sankar — Wed, 01 Jul 2015 04:02:57 GMT

You need to enable the log file on Document settings, General tab, check Generate logfile.

Reload the qlikview.

A tex format logfile will generate in the same location of your qlikview file.

You can go to that folder and open the generated log file and find what the error tells.

Re: Inline script is not work properly

Wed, 01 Jul 2015 04:03:16 GMT

event i make the new file and put the script by writing (not copy paste),

but error still happen.

here with the capture screen

Thank you

Re: Inline script is not work properly

qlikviewwizard — Wed, 01 Jul 2015 04:04:11 GMT

Your provided data is very confusing. Can you attach the sample qvw with sample data. So that it will help us better understanding the issue and to provide the efficient solution by our folks.

Re: Inline script is not work properly

Wed, 01 Jul 2015 04:06:02 GMT

See this:

Measures:

LOAD *

INLINE [

Measure

Sales Count

Sales Amount

];

Re: Inline script is not work properly

Wed, 01 Jul 2015 04:07:16 GMT

Dude

I think he made mistake in script only I try this code many time in my system there is no issue raised but when I edit the script manually , i was ignore the space between "Inline [" and reload the code it seems the same error like as you said. I think u also made the same mistake.. Just see that once again........

Re: Inline script is not work properly

Wed, 01 Jul 2015 04:08:54 GMT

Give the space between "Inline and ["..

Re: Inline script is not work properly

Wed, 01 Jul 2015 04:12:09 GMT

Here its this the log file:

01/07/2015 1:07:52 PM: Execution started.

01/07/2015 1:07:52 PM: QlikView Version:11.20.12904.0

01/07/2015 1:07:52 PM: CPU Target x86

01/07/2015 1:07:52 PM: Operating System Windows 7 Professional Service Pack 1 (32 bit edition)

01/07/2015 1:07:52 PM: Wow64 mode Not using Wow64

01/07/2015 1:07:52 PM: MDAC Version 6.1.7601.17514

01/07/2015 1:07:52 PM: MDAC Full Install Version 6.1.7601.17514

01/07/2015 1:07:52 PM: PreferredCompression 2

01/07/2015 1:07:52 PM: EnableParallelReload 1

01/07/2015 1:07:52 PM: ParallelizeQvdLoads 1

01/07/2015 1:07:52 PM: AutoSaveAfterReload 0

01/07/2015 1:07:52 PM: BackupBeforeReload 0

01/07/2015 1:07:52 PM: EnableFlushLog 0

01/07/2015 1:07:52 PM: SaveInfoWhenSavingFile 0

01/07/2015 1:07:52 PM: UserLogfileCharset 1200

01/07/2015 1:07:52 PM: OdbcLoginTimeout -1

01/07/2015 1:07:52 PM: OdbcConnectionTimeout -1

01/07/2015 1:07:52 PM: ScriptWantsDbWrite false

01/07/2015 1:07:52 PM: ScriptWantsExe false

01/07/2015 1:07:52 PM: LogFile CodePage Used: 1200

01/07/2015 1:07:52 PM: Reload Executed By PC-31345\jadmin

01/07/2015 1:07:52 PM: Process Executing: QlikView Desktop

01/07/2015 1:07:52 PM: Process ID: 6664

01/07/2015 1:07:52 PM: 0002 SET ThousandSep=','

01/07/2015 1:07:52 PM: 0003 SET DecimalSep='.'

01/07/2015 1:07:52 PM: 0004 SET MoneyThousandSep=','

01/07/2015 1:07:52 PM: 0005 SET MoneyDecimalSep='.'

01/07/2015 1:07:52 PM: 0006 SET MoneyFormat='RM#,##0.00;(RM#,##0.00)'

01/07/2015 1:07:52 PM: 0007 SET TimeFormat='h:mm:ss TT'

01/07/2015 1:07:52 PM: 0008 SET DateFormat='DD/MM/YYYY'

01/07/2015 1:07:52 PM: 0009 SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT'

01/07/2015 1:07:52 PM: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

01/07/2015 1:07:52 PM: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

01/07/2015 1:07:52 PM: 0012 SET HidePrefix='%'

01/07/2015 1:07:52 PM: 0014 DimentionList:

01/07/2015 1:07:52 PM: 0015 LOAD * Inline[

01/07/2015 1:07:52 PM: 0016 %Dimentions

01/07/2015 1:07:52 PM: 0017 SalesPerson

01/07/2015 1:07:52 PM: 0018 Country

01/07/2015 1:07:52 PM: 0019 City

01/07/2015 1:07:52 PM: 0020 Product

01/07/2015 1:07:52 PM: 0021 ]

01/07/2015 1:07:52 PM: Error: Syntax error, missing/misplaced FROM:

01/07/2015 1:07:52 PM: DimentionList:

01/07/2015 1:07:52 PM: LOAD * Inline[

01/07/2015 1:07:52 PM: %Dimentions

01/07/2015 1:07:52 PM: SalesPerson

01/07/2015 1:07:52 PM: Country

01/07/2015 1:07:52 PM: City

01/07/2015 1:07:52 PM: Product

01/07/2015 1:07:52 PM: ]

01/07/2015 1:07:54 PM: 0023 expressionList:

01/07/2015 1:07:54 PM: 0024 LOAD * Inline[

01/07/2015 1:07:54 PM: 0025 expressionName

01/07/2015 1:07:54 PM: 0026 Total Sales

01/07/2015 1:07:54 PM: 0027 Total Count

01/07/2015 1:07:54 PM: 0028 Avg. Sales

01/07/2015 1:07:54 PM: 0029 ]

01/07/2015 1:07:54 PM: Error: Syntax error, missing/misplaced FROM:

01/07/2015 1:07:54 PM: expressionList:

01/07/2015 1:07:54 PM: LOAD * Inline[

01/07/2015 1:07:54 PM: expressionName

01/07/2015 1:07:54 PM: Total Sales

01/07/2015 1:07:54 PM: Total Count

01/07/2015 1:07:54 PM: Avg. Sales

01/07/2015 1:07:54 PM: ]

01/07/2015 1:07:56 PM: 0031 Data:

01/07/2015 1:07:56 PM: 0032 LOAD * INLINE [

01/07/2015 1:07:56 PM: 0033 SalesPerson, Country, City, Product, Sales, Orders

01/07/2015 1:07:56 PM: 0034 Joe, Germany, Berlin, Bricks, 129765, 399

01/07/2015 1:07:56 PM: 0035 Joe, Germany, Berlin, Brogues, 303196, 5842

01/07/2015 1:07:56 PM: 0036 Joe, Germany, Berlin, Widgets, 64358, 1603

01/07/2015 1:07:56 PM: 0037 Joe, Germany, Berlin, Woggles, 120587, 670

01/07/2015 1:07:56 PM: 0038 Joe, Germany, Frankfurt, Bricks, 264009, 2327

01/07/2015 1:07:56 PM: 0039 Joe, Germany, Frankfurt, Brogues, 369565, 3191

01/07/2015 1:07:56 PM: 0040 Joe, Germany, Frankfurt, Widgets, 387441, 5331

01/07/2015 1:07:56 PM: 0041 Joe, Germany, Frankfurt, Woggles, 392757, 735

01/07/2015 1:07:56 PM: 0042 Joe, Germany, Munich, Bricks, 153952, 1937

01/07/2015 1:07:56 PM: 0043 Joe, Germany, Munich, Brogues, 319644, 645

01/07/2015 1:07:56 PM: 0044 Joe, Germany, Munich, Widgets, 47616, 2820

01/07/2015 1:07:56 PM: 0045 Joe, Germany, Munich, Woggles, 105483, 3205

01/07/2015 1:07:56 PM: 0046 Brian, Japan, Osaka, Bricks, 17086, 281

01/07/2015 1:07:56 PM: 0047 Brian, Japan, Osaka, Brogues, 339902, 2872

01/07/2015 1:07:56 PM: 0048 Brian, Japan, Osaka, Widgets, 148935, 1864

01/07/2015 1:07:56 PM: 0049 Brian, Japan, Osaka, Woggles, 142033, 2085

01/07/2015 1:07:56 PM: 0050 Brian, Japan, Tokyo, Bricks, 161972, 1707

01/07/2015 1:07:56 PM: 0051 Brian, Japan, Tokyo, Brogues, 387405, 2992

01/07/2015 1:07:56 PM: 0052 Brian, Japan, Tokyo, Widgets, 270573, 3212

01/07/2015 1:07:56 PM: 0053 Brian, Japan, Tokyo, Woggles, 134713, 5522

01/07/2015 1:07:56 PM: 0054 Brian, Japan, Yokohama, Bricks, 147943, 4595

01/07/2015 1:07:56 PM: 0055 Brian, Japan, Yokohama, Brogues, 405429, 6844

01/07/2015 1:07:56 PM: 0056 Brian, Japan, Yokohama, Widgets, 266462, 3158

01/07/2015 1:07:56 PM: 0057 Brian, Japan, Yokohama, Woggles, 477315, 5802

01/07/2015 1:07:56 PM: 0058 Joe, UK, Birmingham, Bricks, 23150, 1754

01/07/2015 1:07:56 PM: 0059 Joe, UK, Birmingham, Brogues, 200568, 1763

01/07/2015 1:07:56 PM: 0060 Joe, UK, Birmingham, Widgets, 262824, 617

01/07/2015 1:07:56 PM: 0061 Joe, UK, Birmingham, Woggles, 173118, 5359

01/07/2015 1:07:56 PM: 0062 Joe, UK, London, Bricks, 621409, 712

01/07/2015 1:07:56 PM: 0063 Joe, UK, London, Brogues, 504268, 2873

01/07/2015 1:07:56 PM: 0064 Joe, UK, London, Widgets, 260335, 1313

01/07/2015 1:07:56 PM: 0065 Joe, UK, London, Woggles, 344435, 743

01/07/2015 1:07:56 PM: 0066 Joe, UK, Manchester, Bricks, 401928, 1661

01/07/2015 1:07:56 PM: 0067 Joe, UK, Manchester, Brogues, 7366, 2530

01/07/2015 1:07:56 PM: 0068 Joe, UK, Manchester, Widgets, 6108, 5106

01/07/2015 1:07:56 PM: 0069 Joe, UK, Manchester, Woggles, 269611, 4344

01/07/2015 1:07:56 PM: 0070 Mary, USA, Boston, Bricks, 442658, 3374

01/07/2015 1:07:56 PM: 0071 Mary, USA, Boston, Brogues, 147127, 3129

01/07/2015 1:07:56 PM: 0072 Mary, USA, Boston, Widgets, 213802, 1604

01/07/2015 1:07:56 PM: 0073 Mary, USA, Boston, Woggles, 395072, 1157

01/07/2015 1:07:56 PM: 0074 Michael, USA, Dallas, Bricks, 499805, 3378

01/07/2015 1:07:56 PM: 0075 Michael, USA, Dallas, Brogues, 354623, 18

01/07/2015 1:07:56 PM: 0076 Michael, USA, Dallas, Widgets, 422612, 2130

01/07/2015 1:07:56 PM: 0077 Michael, USA, Dallas, Woggles, 217603, 2612

01/07/2015 1:07:56 PM: 0078 Mary, USA, New York, Bricks, 313600, 6468

01/07/2015 1:07:56 PM: 0079 Mary, USA, New York, Brogues, 559745, 1743

01/07/2015 1:07:56 PM: 0080 Mary, USA, New York, Widgets, 94558, 2910

01/07/2015 1:07:56 PM: 0081 Mary, USA, New York, Woggles, 482012, 3173

01/07/2015 1:07:56 PM: 0082 Michael, USA, San Diego, Bricks, 95594, 4214

01/07/2015 1:07:56 PM: 0083 Michael, USA, San Diego, Brogues, 24639, 3337

01/07/2015 1:07:56 PM: 0084 Michael, USA, San Diego, Widgets, 107683, 5257

01/07/2015 1:07:56 PM: 0085 Michael, USA, San Diego, Woggles, 221065, 5058

01/07/2015 1:07:56 PM: 0086 ]

01/07/2015 1:07:56 PM: 6 fields found: SalesPerson, Country, City, Product, Sales, Orders, 52 lines fetched

01/07/2015 1:07:56 PM: Execution finished.

Re: Inline script is not work properly

Wed, 01 Jul 2015 04:16:22 GMT

Dear Abinesh S

Thank you for your help.

it would be worked.

because space between "inline" and "["

Re: Inline script is not work properly

PrashantSangle — Wed, 01 Jul 2015 04:41:28 GMT

Hi,

This error occured because there is no space between "inline" keyword and "["

Regards

Re: Inline script is not work properly

qlikviewwizard — Wed, 01 Jul 2015 05:21:03 GMT

Hi Mahmud178

Please close the thread by clik on Correct Answer

Re: Inline script is not work properly

jagan — Wed, 01 Jul 2015 05:33:13 GMT

Hi,

After Inine keyword you have to give space, then you wont get this error.

LOAD

INLINE [ ---- Correct

Somevalues];

LOAD

INLINE[ ---- Error

Somevalues];

Hope this helps you.

Regards,

Jagan.

Re: Inline script is not work properly

Wed, 01 Jul 2015 06:01:10 GMT

Hi YY Hid,

After Inline there should be space and then '[' this should be started. see the below code and try

LOAD * INLINE [

%Dim

];