topic Adding Square Brackets in Load Inline statement in QlikView

Adding Square Brackets in Load Inline statement

Thu, 14 Jul 2011 08:25:22 GMT

Hi Community,

Is it possible to add square brackets in LoadScript?

Here's my sample code but this throws error "Garbage after statement"

[Code]

Load * Inline [

Formula, Value

NetSales, Sum([Net Sales])

];

[/Code]

Any Idea?

Thanks in advance!

Ronald

Anonymous — Thu, 14 Jul 2011 08:36:18 GMT

To my knowledge it is not possible to use square brackets in an inline load. I think you would have to do this in two steps.

raw:

LOAD * Inline [
FIELD1, VALUE
];

rich:
LOAD
FIELD1,
Sum([VALUE])
Resident raw
Group By FIELD1;

DROP Table raw;

Or, simply don't use spaces in your fieldnames. That way you don't need square brackets.

Thu, 14 Jul 2011 08:42:25 GMT

Thanks for the response!

Yes its not possible to add a square brackets I used quotes instead and now its working fine!

Load * Inline [

Formula, Value

NetSales, Sum("Net Sales")

];

Regards,

Ronald

Thu, 14 Jul 2011 08:49:53 GMT

How about using variables where the value is set to the expression?

Depending on how you use it you may need to include an aggregation over any chart dimensions.

Regards,

Gordon