topic Re: How to load inline, when the text contains this character [ ? in QlikView

How to load inline, when the text contains this character [ ?

Fri, 12 Apr 2013 09:44:41 GMT

Hi there,

I'm trying to achieve something simple, but without success. I hope there are some bright ideas from your side...

What I'm trying to do is load an inline table. That is normally no issue, but my table contains these characters: [ and ] , and that causes trouble.

Example of my loadscript:

Test:

load * inline [

Expression

SUM( {[Comparison]} Ordered )

];

The issue obviously is caused by the red marked characters (I don't know the english word for this character).

My question actually is: How can I escape them, so this formulatext is loaded properly?

I tried to surround it with single and double quotes and additional [ and ], but no success yet.

Thanks in advance!

Roberto

Re: How to load inline, when the text contains this character [ ?

Gysbert_Wassenaar — Fri, 12 Apr 2013 15:59:18 GMT

Sometimes I think Henric is psychic. This blog post appeared just days before you asked your question. Instead of [ and ] you can use the other quote types for the start and end characters of the inline block.

Re: How to load inline, when the text contains this character [ ?

eddysanchez — Fri, 12 Apr 2013 17:35:22 GMT

Test1:

LOAD * INLINE [

Expression

"SUM( {[Comparison<corchete>} Ordered )"

];

Test:

LOAD Replace(Expression,'<corchete>',']')

Resident Test1;

DROP Table Test1;

Re: How to load inline, when the text contains this character [ ?

Sat, 13 Apr 2013 11:32:35 GMT

Thanks for both answers.

Eddy's reply is the workaround I was already using.
Gysberts reply is "new" to me (I didn't know that I could use double quotes too in an expression with alternate states). So this solution works for me.

But (just for the record) do I understand it correct that I cannot load text with [ and ] (in a perhaps theoretical scenario)?

Roberto

Re: How to load inline, when the text contains this character [ ?

Gysbert_Wassenaar — Sat, 13 Apr 2013 18:05:07 GMT

No, you can load text with [ and ] characters. Only when you use an inline load you have to make sure that either the inline block doesn't start and end with [ and ] or your text doesn't contain those characters. Like this for example:

Test:

load * inline "

Expression

SUM( {[Comparison]} Ordered )

" ;

Re: How to load inline, when the text contains this character [ ?

Sat, 13 Apr 2013 21:43:46 GMT

Clear again, thanks!

Miguel Angel Baeyens <qcwebmaster@qlik.com> schreef:

QlikCommunity

Re: How to load inline, when the text contains this character [ ?

reply from Miguel Angel Baeyens in Development (QlikView Desktop) - View the full discussion

No, you can load text with characters. Only when you use an inline load you have to make sure that either the inline block doesn't start and end with or your text doesn't contain those characters. Like this for example:

Test:

load * inline "

Expression

SUM( {[Comparison]} Ordered )

" ;

Reply to this message by replying to this email -or- go to the message on QlikCommunity

Start a new discussion in Development (QlikView Desktop) by email or at QlikCommunity

This e-mail is personal. For our full disclaimer, please visit www.centric.eu/disclaimer.