topic Creating a visualization with custom data in Integration, Extension & APIs

Creating a visualization with custom data

master_t — Sat, 16 Nov 2024 05:41:34 GMT

Hi everyone

I'm trying to use the visualization API to create a chart on the fly, as described here:

https://help.qlik.com/en-US/sense-developer/June2018/Subsystems/Mashups/Content/Create/Visualizations/Barchart/create-barchart.htm

However, I don't want to use dimensions/measures already in the model for this, I would like to supply my own data directly via javascript.

First of all, is this even possible? And if so, how?

I've tried something like this:

app.visualization.create( 'barchart', [ "=ValueList('a', 'b', 'c')", //this dimension definition works "???" //but how do I define the measure?? Is it possible? ], { "showTitles": true } ) .then((vis) => { vis.show("graphContainer"); });

I've managed to create the dimension on the fly using the ValueList function, but the problem is that I don't know how to define an associated measure in a similar way. Can it even be done?

Re: Creating a visualization with custom data

ajaykakkar93 — Wed, 09 Oct 2019 10:50:33 GMT

Hi,

Her it what you can do

app.visualization.create( 'barchart', [ "=ValueList('a', 'b', 'c')","=sum(2)"], { "showTitles": true } ) .then((vis) => { vis.show("graphContainer"); });

regards,

Ajay Kakkar

Re: Creating a visualization with custom data

master_t — Wed, 09 Oct 2019 11:20:31 GMT

Thanks, but what I actually wanted to do is pass in the values, not a function.

I managed to do this by using a measure definition like this:

=Pick(RowNo(), "1, 2, 3, ...")