topic Re: Create chart using script? in QlikView

Create chart using script?

sayaleesangle — Wed, 25 Nov 2020 16:16:04 GMT

How can we create the chart (Bar chart,line chart etc.) using script? in the Qlikview?

Re: Create chart using script?

Anil_Babu_Samineni — Wed, 23 May 2018 23:38:12 GMT

Nit sure about your request. Charts comes and design from charts

Re: Create chart using script?

qlikviewwizard — Thu, 24 May 2018 03:26:04 GMT

We won't create charts with script but we will create data sets/table.

Re: Create chart using script?

Peter_Cammaert — Thu, 24 May 2018 06:52:14 GMT

You cannot create charts from the script (no DOM, no ActiveDocument so no working API functions that manipulate the DOM)

If you're working in QV Desktop however, you can create all the necessary data tables and variables in your script, add a suitable macro that creates the object(s) you want to see, and run the macro using the OnPostReload trigger.

Examples of how to create objects using mcaros? See here: Macro generates chart but continously and I want once or here: Create Custom Chart with Macro

Re: Create chart using script?

sayaleesangle — Thu, 24 May 2018 07:00:39 GMT

I got the below script on the internet but as I am new to QlikView I am unable to understand it..If anyone having knowledge about it please tell me.

Thank you

Load file(s) into TABLE1
declare X integer
, total_columns integer
, field_name varchar
set X = 1
set total_columns = count(columns) from TABLE1
While X <= total_columns
begin
Set field_name = name(columnnumber(X))
Create_chart [name: chart + string(X)
, type: barchart
, x_axis: columnnumber(X)
, y_axis: count(*)
, title: field_name
, appearance: default]
X = X + 1
end
Auto-arrange page

Re: Create chart using script?

Peter_Cammaert — Thu, 24 May 2018 16:04:53 GMT

Since "the internet" is a huge repository of scripts in various programming languages, the script you posted may be targeted to a product that is unrelated to those by Qlik. Do you know what language it is written in?

BTW QlikView macros can be written in either VBScript or JavaScript. AFAIK VBScript is the more popular macro programming lagnuae (although it is seriously less powerful than JavaScript)

Re: Create chart using script?

Anonymous — Sun, 27 May 2018 19:01:18 GMT

Dear Sayalee,
In QlikView for chart visualizations we can use from given style or can use extensions for customized chart.
We can write some expressions for charts in scripting.