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