topic QV11 Editor Problem in QlikView

QV11 Editor Problem (inline load)

Tue, 21 Feb 2012 10:06:09 GMT

While using an inline load in QV11, i stumbeled upon a problem.

// comments in the inline load

were not ignored, but loaded inline.

This resulted in this strange collumn:

// comments work fine outside inline loads.

It seems this is a bug, or is there a way to prevent this ?

QV11 Editor Problem

CELAMBARASAN — Tue, 21 Feb 2012 10:13:13 GMT

Hi,

I think its not a bug its inline functionality.

It process everything Inside the [ ].

It takes first rows as field names and after that as field values.

Celambarasan

QV11 Editor Problem

jagan — Tue, 21 Feb 2012 10:59:37 GMT

Hi,

It is not a bug. Qlikview treats // as a value in in Inline[]; It is not possible to comment in Inline. Instead you just remove that line directly or else filter this using where condition.

Hope this helps you.

Regards,

Jagan.

QV11 Editor Problem

Thu, 23 Feb 2012 08:47:48 GMT

great, so its "not" a bug, its a feature...

at least there is the option to filter out the comments (which should be QVs job)

QV11 Editor Problem

jagan — Thu, 23 Feb 2012 13:39:12 GMT

Hi,

Try the following script

Temp:

Load

FROM DataSource;

Data:

LOAD

RESIDENT Temp

WHERE Left(LTrim(MS), 2) <> '//';

This would remove the rows with '//'.

Hope this helps you.

Regards,

Jagan.