Using DynamicUpdateCommand()

Fri, 19 Aug 2011 10:57:46 GMT

I'm playing with QlikView and was wondering if anyone has any experience with DynamicUpdateCommand()?

I can quite simpy get a .qvw file loaded and to display on a form.
I can use doc.RemoveAllData(true) to, well, remove all the data.
I can't get DynamicUpdateCommand() to do Anything at all...

Literally, RemoveAllData() changes what I see (Everything vanishes), and DynamicUpdateCommand() changes absolutely nothing on the screen at all...

Does anyone know what I should be doing, or am doing wrong?

Sample code outside of my form...

QlikView = new Form2();
QlikView.LoadDocument(@"C:\myPath\myDashboard.qvw");
QlikView.Show(this);
QlikView.DoJiggeryPokery(@"INSERT INTO DataRuns (RunID, Value) VALUES (1, 1)");

Sample code for my form...

public partial class Form2 : Form
{
    private QlikView.Doc document; 

    public Form2() {
        InitializeComponent();
    }

    public void LoadDocument(string filename) {
        document = axQlikOCX.OpenDocument(filename);
    }

    public void DoJiggeryPokery(string command) {
        //document.RemoveAllData(true);
        document.DynamicUpdateCommand(command);
        //document.Reload(0);
    }
}

I'm using the OCX for QlikView 9.0.0

topic Using DynamicUpdateCommand() in QlikView

Using DynamicUpdateCommand()