Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bgarland
Contributor III

Help with Custom Extension

I played a bit with creating this document extension but haven't had a lot of success. This extension is specific to just one application so it doesn't matter if I hard-code in object and variable names. Here's an example:

  • QVW has 10 straight table charts.
  • I have created ten variables that are to contain the row count of each table, given any data selections.
  • The document extension keeps these ten variables updated with the current row count of each respective chart.

So the extension simply needs to inspect each chart, get the current row count, set the corresponding variable to that row count. Should be easy but I don't know how to do it.

1 Reply
bgarland
Contributor III

Re: Help with Custom Extension

So this seems to work. If anyone can help optimize this, probably by using a loop, I'd appreciate it.

  var vDoc = Qv.GetCurrentDocument();

  var vCHTest1 = vDoc.GetObject("CHTest1");

  var vCHTest2 = vDoc.GetObject("CHTest2");

  var vCHTest3 = vDoc.GetObject("CHTest3");

 

  vCHTest1.SetOnUpdateComplete(function() {

  vRows = this.Data.TotalSize.y;

  vDoc.SetVariable("vCHTest1RowCount",vRows);

  });

  vCHTest2.SetOnUpdateComplete(function() {

  vRows = this.Data.TotalSize.y;

  vDoc.SetVariable("vCHTest2RowCount",vRows);

  });

  vCHTest3.SetOnUpdateComplete(function() {

  vRows = this.Data.TotalSize.y;

  vDoc.SetVariable("vCHTest3RowCount",vRows);

  });