topic Creating a dynamic straight table from load script table in QlikView

Creating a dynamic straight table from load script table

Sun, 15 Nov 2009 12:19:17 GMT

All -

Trying to figure out a way to create a straight table box chart on the Main sheet as the document opens, and dynamically add the fields in the table created in a loadscript. The reason for this is that the table in loadscript is drawn from Oracle metadata tables and the field list will be variable.

the painfully manual alternative is to manually create the chart each time there is a change in the underlying table structures.

Any insight appreciated. Thanks,

Chris

Creating a dynamic straight table from load script table

sparur — Sun, 15 Nov 2009 19:02:03 GMT

Hi, Chris.

I think that you should create a macros, which will dynamic create a chart Object. See more details in APIguide.qvw.

But it's good idea only if you know WHAT fields are DIMENSIONs and what fields are MEASUREs (for using in expression tab)

best regards, Anatoly.

Creating a dynamic straight table from load script table

Mon, 16 Nov 2009 05:29:03 GMT

I agree that I should be able to, but all I get with the macros is the gray bar indicating that the chart object is created, with no error for the rest of the code, but no fields added to the chart:

Sub make_chart

set chart = ActiveDocument.GetSheet(1).CreateStraightTable

chart.AddDimension(DEAL_CD)

chart.AddExpression(DEAL_NAME)

End Sub

Any thoughts on how to get this to work? The DEAL_CD, DEAL_NAME are fields created in a table in the load script.

Creating a dynamic straight table from load script table

Mon, 16 Nov 2009 05:35:59 GMT

have also tried this to same effect (creates gray bar but no fields)

chart.AddDimension "DEAL_CD"

Creating a dynamic straight table from load script table

sparur — Mon, 16 Nov 2009 15:14:11 GMT

Hi, Chris.

Look at my example (in attachments)

regards, Anatoly

Creating a dynamic straight table from load script table

Mon, 16 Nov 2009 18:22:04 GMT

That does the same thing, just created the stub of a Straight Table - the top bar with min/max controls on the right. With no fields/columns in it.

Creating a dynamic straight table from load script table

Mon, 16 Nov 2009 18:23:08 GMT

Is there something subsequent to this step to add the data from the table that was created in the load script?

I also opened the table and on the dimension tab, no dimensions are added. On the expression tab, no expressions are added.

Creating a dynamic straight table from load script table

sparur — Mon, 16 Nov 2009 18:33:39 GMT

what version Do you use?

Because? after I pressed the button, I see a good straight Table:

regards, Anatoly

Creating a dynamic straight table from load script table

Mon, 16 Nov 2009 18:38:01 GMT

9.00.7119.4

Creating a dynamic straight table from load script table

Mon, 16 Nov 2009 18:42:29 GMT

This is what happens:

Edit Module Box pops up and the stub of a table is created:

Creating a dynamic straight table from load script table

sparur — Mon, 16 Nov 2009 18:49:27 GMT

first try to reload script, then press button.

I have a QV 9.0 SR2 but this code worked also in 8.5

Creating a dynamic straight table from load script table

Mon, 16 Nov 2009 19:22:26 GMT

I thought that would work once you mentioned it, but no dice.

Creating a dynamic straight table from load script table

sparur — Mon, 16 Nov 2009 19:28:28 GMT

may be it's bug in your QV Build?

Can you try this example on QV 9 SR1 ?

Creating a dynamic straight table from load script table

Mon, 16 Nov 2009 19:32:39 GMT

I agree. Downloading the update. Anyhow thanks for your help!

Creating a dynamic straight table from load script table

Wed, 10 Mar 2010 16:01:27 GMT

Hi Guys,

I tried it and I got the same error. I doubt that we both have a bg in te build.

Creating a dynamic straight table from load script table

Thu, 11 Mar 2010 15:11:05 GMT

Hi, I got the same error too.

I finally managed to get it to work, although the "solution" seems a little odd ...


sub chartmaker()
 set tbl = ActiveDocument.Sheets(0).CreateStraightTable
 tbl.AddExpression "sum(Amount)" 'add expressions first
 tbl.AddDimension "Product"
 set tbl = nothing
end sub

After stretching the code in many ways, I noticed that it would make it just by swapping two lines in Anatoly's code (ie adding expressions first, and then dimensions).

Hope this will help

Hilaire