topic Re: Random graphs in Qlikview in QlikView

Random graphs in Qlikview

Mon, 09 Jan 2017 11:48:27 GMT

Dear All,

If we have a table with n number of fields with string, number and date.

We should be able to create multiple combination of graphs for the same.for eg.

use below logic

Sub combin()k = 1For l = 1 To 6 v1 = Cells(l, 1) For m = l To 6 v2 = Cells(m, 2) Cells(k, 3) = v1 & v2 k = k + 1 NextNextEnd Sub

Any suggestions.

Thanks,

Kishore.

Re: Random graphs in Qlikview

petter — Mon, 09 Jan 2017 12:08:12 GMT

It is definitely possible to create multiple charts using a random selection of fields from one or more tables in QlikView.

However to make something useful it is important to have a well thought out plan.

The code can be written in VBScript in a Macro in QlikView or it can be made from an external programming environment through Windows Automation by using QlikView COM-object and its object model.

The number of lines of code would be at least an order of magnitude or two more than the pseudo-code you suggested. The Cells would not be used to create the charts though because everything in QlikView is based on Dimensions and Expressions (measures) that will together render the cells as a result.

Excel is cells-based whereas QlikView is Dimension, Expression and Fields based.

Re: Random graphs in Qlikview

MarcoWedel — Tue, 10 Jan 2017 21:32:09 GMT

Hi,

maybe helpful:

Dynamic chart creation via script...

regards

Marco