topic creating bar graph via macro in QlikView

creating bar graph via macro

Mon, 07 Sep 2009 19:55:39 GMT

Hello everybody,

I'd like build a bar graph programatically via macro script.

I found sometihig like this in API tutorial

set Graph = ActiveDocument.Sheets("Assistenza").CreatePieChart

Graph.AddDimension "C_ARTICOLO_8"

Graph.AddExpression "sum([Quantità transazione])"

Graph.AddExpression "sum(%)"

end sub

My problem is thsat the Expression in not a function of any DIMENSION but values coming from another linear table.

Is there any function or method allow me to build a dimension with values from another table(graph).?

Something creating dimension on the fly?

Thank you for reading y post.

Denis Matteazzi

creating bar graph via macro

stephencredmond — Mon, 07 Sep 2009 20:08:24 GMT

Hi Denis,

Sound like you need AGGR.

AGGR will create a "virtual" chart in memory and you can then apply other functions (e.g. SUM, MAX, AVG, etc.) to the results.

AGGR can also be used to calculate dimensions.

Have a look in the help file. If you can't find what you are looking for, post a more detailed example of your query and we may be able to show you how to achieve what you are doing.

Regards,

Stephen

creating bar graph via macro

Mon, 07 Sep 2009 21:45:10 GMT

Hi thank for the quick answer but i don't know if AGGR could help me.

I have a linear table like this:

col1 col2 col3 col4 col5 res = function(col1,col2,col3,col4,col5)

Item1 10 3 5 7 8 2,5

Item2 3 4 3 1 3 1,8

I'd like use Art1,Art2 as values for bar graph (it's ok because Item1 and Item2 is already a DIMENSION) and the value of res for the expression.

Is there any way of make programatically a DIMENSION starting from values of res?

I hope it's clear,,but I doubt 🙂

creating bar graph via macro

Oleg_Troyansky — Mon, 07 Sep 2009 22:41:15 GMT

I recommend that you build an example and post it here, it will be easier for people to offer solutions.

creating bar graph via macro

Tue, 08 Sep 2009 02:48:22 GMT

I added as an attachment the qlick file so you can help me with an example.

Thank you very much.

creating bar graph via macro

Oleg_Troyansky — Tue, 08 Sep 2009 04:29:09 GMT

no attachment - please double check

creating bar graph via macro

Tue, 08 Sep 2009 13:56:04 GMT

it seems like I am not allowed to upload the attachment. Everything seems to be ok but I can't see my att.

creating bar graph via macro

Tue, 08 Sep 2009 13:58:04 GMT

here