Random graphs in Qlikview

[#1]

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.

[petter]

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.  

[MarcoWedel]

Hi,

maybe helpful:

Dynamic chart creation via script...

regards

Marco