Use ajax component to create an embedded QlikView object

Submitted by seebach on Thu, 07/09/2009 - 10:56

I've wanted to write about this for a long time. You can really do some cool stuff with the ajax tools and regular html pages.

So what I want to do is to add some QlikView objects to a regular html page, and have them behave just is in QlikView. When I select something i one box then it propergates the selection to the others.

You need a QlikView server with a test document first of all. Perhaps you want to publish it as a ajax document, that will give you most of the needed code. Specially the part in head tags is needed, you must copy all lines with <link /> and <script /> (only script tags that include a src= property) tags into your own file. And have them run before what I write below. You need to change the values of qva.View and qva.Autoview to fit your own files:

<script language="javascript" 
type="text/javascript" 
xmlns:msxsl="urn:schemas-microsoft-com:xslt" 
xmlns:zfp="uri:zfp" xmlns:user="uri:user"
 xmlns="">
	var qva = new Qva.PageBinding();
	//QlikView file without .qvw extension		
	qva.View = "QlikViewFile"; 
	// set the sheet to be used
	qva.Autoview = "SH02;"
	// This will iniate it all	
	new Qva.Scanner(qva);
	
</script>

You then must use an onload event to get the above code triggered, and get the QlikView javascript to render the page items.

<body onload="Qva.Start()" >

Then add some html like this, which you can copy paste from generated ajax file, remember to change the object id, here its LB495:

<table style="width:auto;" avq="table" 
avqbody="true" AvqAsync="20:.LB495" 
class="ListBox"></table>

I hope you enjoy this :) Regards Seebach

Adding whole sheet

Submitted by Anonymous on Tue, 09/27/2011 - 08:48.

How can I add whole sheet to a workbench project in Visual Studio? I want all the objects from the sheet to be in my web page, so instead of adding all the objects one after another, can I be able to add whole sheet with all of its objects? In this case, all the objects will stick to the sheet and will not be misplaced. Any idea? BTW very nice and informative article, so I thought I should ask here. Regards

Hello SeeBach

Submitted by Anonymous on Tue, 09/01/2009 - 09:50.

Its really quite interestiing reading your post.
I am highly interesting in doing this. Can you send me a zip file containing the demo of this.
I tried this but its of no use.

Email-ID===== atuliiitmgmailcom
Thanks Atul,

QlikView WorkBench

Submitted by Anonymous on Fri, 07/10/2009 - 17:37.

You sure can do some cool stuff integrating QlikView on the web - There is also the QlikView WorkBench which helps with this:
http://qlikwebworkbench.com/Support/Default.aspx

Which contains ASP.NET controls for VS.NET developers as well as a library of JavaScript helper classes and additional controls (the reference site shows many examples of it in action at http://www.qlikwebworkbench.com/refsite/).

I'll also be posting some more html/javascript based samples soon on my own blog at:
http://www.qlikster.com

It's great to others writing about the possibilities with QlikView!