Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using DynamicUpdateCommand()

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

0 Replies