Chart-Level Script - Add Load

Jim_Ogilvie — Tue, 31 May 2022 08:48:45 GMT

Hi guys,

So, after the impressive Qlik in 60 video on Chart-Level scripting, I thought I'd jump right in and experiment a little.

There isn't much in the way of walkthrough demos, so I've been using Qlik's developer guide to try a few things out.

I'm have trouble at the first hurdle, with the seemly simple task of adding some new data to that already loaded in the bar chart object I'm working with. I keep getting a "Unexpected Dynamic Script Error".

Here's my code:

Add Load
x as Year,
y as [Sales Amount]
Inline
[
Year,SalesAmount
2023,10000000
2024,20000000
]
;

And here's the code from the Qlik documentation:

Add Load
x as Dates,
y as Sales
Inline
[
Dates,Sales
2001/09/1,1000
2001/09/10,-300
]

Re: Chart-Level Script - Add Load

Andrew_Delaney — Wed, 08 Jun 2022 08:52:41 GMT

Hi Jim,

It looks like the code you are basing this off is unfortunately wrong.

Sense is looking for x and y in your inline data and failing to find it.

So what you are after here is:

Add Load
x as Year,
y as [Sales Amount]
Inline
[
x,y
2023,10000000
2024,20000000
]
;

Which will load into your data model 2 fields named Year and Sales Amount with the values you have put in place

topic Re: Chart-Level Script - Add Load in App Development

Chart-Level Script - Add Load

Re: Chart-Level Script - Add Load