Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Not applicable

Error in LOAD INLINE statement

Hi All,

I have types in one table, I loaded that table in the Qlikview. I have written a INLINE statement to map that types.

tab1:

SELECT Type from table A;

Maptopups:
LOAD * INLINE [
Type, Map_Type
, Others
[M Negative Adjus], Others
[M positive Adjus], Others
, E
[E Cancellation], E cancellation
, V
];

I am getting "Garbage value error" after executing the above INLINE statement.

What is wrong in the INLINE statement.

-raghu.

1 Solution

Accepted Solutions
Not applicable

Error in LOAD INLINE statement

Remove the brackets from the data values.

e.g

M, Others

M Negative Adjus, Others

3 Replies
Not applicable

Error in LOAD INLINE statement

Remove the brackets from the data values.

e.g

M, Others

M Negative Adjus, Others

Highlighted
afuchten
Valued Contributor

Error in LOAD INLINE statement

LOAD INLINE instead of LOAD * INLINE ...
Maybe the [ ] between the LOAD INLINE [ ] could also give problems?

Try something like below:



tab1:
SELECT Type from table A;

Maptopups:
LOAD INLINE [ Type, Map_Type
'M',Others
'M Negative Adjus',Others
'M Positive Adjus', Others
];


Not applicable

Error in LOAD INLINE statement

Thanks to both of you. Problem with the brackets.

-Raghu